Richard has attended:
Access Advanced course
Access Intermediate course
Access VBA course
Data access page
can i create a drop down box which will automatically update all other fields?
RE: data access page
Hi again Richard, Thanks for the post, I had to dig deep to find an answer to your question. Consider we have two tables tblSuppliers and tblProducts, they should be joined through a common field (One supplier - Many products) eg SupplierID.
1. Create Two Data Access Pages one from each of the tables.
2. To view the products supplied by a particular Supplier, open the DAPage for Suppliers in Design view,
3. Display the field list and expand the Tables folder to view the list of tables in the database,
4. Expand the table for Products to view all the fields, drag the Product_name field (for example) to the Suppliers DAPage, if necessary confirm the link field, select display type ie Columnar,
5. Right Click the new control and choose Group Filter Control, the control is now a drop down field and will show Supplier data for each Product chosen in the drop down.
