third page on form only showing one series of records

[S.Hoitinga]

HI,

I encountered a very strange problem in access 2000 and I don't know how to
fix this.

I have created a form with three pages or sheettabs.
On the first page general information about a client is presented from the
table tblClients with keyfield ClientNr.
The second page contains related information about placed orders. These data
come from
a table called tblOrders. This table stores general information about an
order, like date, clientnr, transport,
dateofdelivery, personelnr.
The link between the two pages is supported by a subform based on a query
with a criterium
defined as forms!frmOrderinformation!ClientNr. Everything works just fine.
When I browse through the clients on the first page and then have a look on
the second page I get the information
about the placed orders that I have in table tblOrders.
I then created a third page in the form.
On this page I want to show the related information with the order. This
related information comes from a junctiontable called tblOrderRules. I
followed the same procedure: create a form based on a query with criterium
forms!frmClientinformation!frmPlacedOrders!OrderNr.
When I browse through the first page of the form, I read information about
my clients. When there is an order on the second page on the form I read the
general information about the placed order. When I then move on to the third
page,
I read information about the ordered articles, the number of articles
ordered, the totals etc. Everything works just fine.

A problem arises however, when the same client has placed two or more
orders. When on the second page I find
two placed orders and look on the third sheet, I find the related
information only of the first order.
This also happens when I select the second or third OrderNr field!!!!!
Somehow the criterium is not working for second and third OrderNr fields.

Can anybody please help me with solving this strange problem.

Any help is greatly appreciated.

Sybolt

 

[Damien McBain]

HI,

I encountered a very strange problem in access 2000 and I don't know
how to fix this.

I have created a form with three pages or sheettabs.
On the first page general information about a client is presented
from the table tblClients with keyfield ClientNr.
The second page contains related information about placed orders.
These data come from
a table called tblOrders. This table stores general information about
an order, like date, clientnr, transport,
dateofdelivery, personelnr.
The link between the two pages is supported by a subform based on a
query with a criterium
defined as forms!frmOrderinformation!ClientNr. Everything works just
fine. When I browse through the clients on the first page and then
have a look on the second page I get the information
about the placed orders that I have in table tblOrders.
I then created a third page in the form.
On this page I want to show the related information with the order.
This related information comes from a junctiontable called
tblOrderRules. I followed the same procedure: create a form based on
a query with criterium
forms!frmClientinformation!frmPlacedOrders!OrderNr.
When I browse through the first page of the form, I read information
about my clients. When there is an order on the second page on the
form I read the general information about the placed order. When I
then move on to the third page,
I read information about the ordered articles, the number of articles
ordered, the totals etc. Everything works just fine.

A problem arises however, when the same client has placed two or more
orders. When on the second page I find
two placed orders and look on the third sheet, I find the related
information only of the first order.
This also happens when I select the second or third OrderNr field!!!!!
Somehow the criterium is not working for second and third OrderNr
fields.

Can anybody please help me with solving this strange problem.

Any help is greatly appreciated.

Sybolt

Pretty shit if your customers can only place 1 order

Show us the structure

 

[S.Hoitinga]

Pretty shit if your customers can only place 1 order

Show us the structure

It's not so much that they can only place 1 order.
The problem is that when I check for the orders in the threepage form the
third page only shows the order details
of the first order of the second page.

What do you mean with: show us the structure?

sybolt