MS Access, Records Returned in a Form Must Be Based on Key ID field on another form

Records Returned in a Form Must Be Based on Key ID field on another form

Author	Message
Nick Gross #1 / 2	Records Returned in a Form Must Be Based on Key ID field on another form Any way to design a form so that when it is opened it returns records whose ID matches the same ID value that is active on another form? (I don't want to get into sub forms). For example. Say I have a form that lists Products - suppose "Product X" is the active record. Suppose as well I have a form that shows Customer Orders. With the Product form already open, when I open the Customer Orders form, I want it such that only Customers who order "Product X" are returned.
Thu, 17 Oct 2002 03:00:00 GMT

Shahram Alemzade #2 / 2	Records Returned in a Form Must Be Based on Key ID field on another form Define a query to select all records from customer orders table where ID is equal to Forms![products]![ID] and set this query as the record source of customer orders form. Shahram Quote: > Any way to design a form so that when it is opened it returns records > whose ID matches the same ID value that is active on another form? (I > don't want to get into sub forms). > For example. Say I have a form that lists Products - suppose "Product > X" is the active record. Suppose as well I have a form that shows > Customer Orders. With the Product form already open, when I open the > Customer Orders form, I want it such that only Customers who order > "Product X" are returned.
Sat, 19 Oct 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]