Access 2000

[Barry]

I have created a data base.
One page has a sub form inserted with Product drop down
boxes.
All works fine except the drop down information is not
retained on the page once it is closed
Can you assist
Many Thanks

 

[John Vinson]

I have created a data base.
One page has a sub form inserted with Product drop down
boxes.
All works fine except the drop down information is not
retained on the page once it is closed
Can you assist
Many Thanks

Access doesn't store data on pages (or on Forms either, which I think
must be what you mean).

It stores data in Tables. Data in a Table can be displayed on a Form.

What is the "Recordsource" of this Form (the table or query containing
the data it displays)? What is the Control Source of the combo box
("dropdown")? What are that combo box's RowSource and Bound Column
properties? The combo box will pull data from its Rowsource (the
Product table); it will store one of those fields - the one indicated
by its Bound Column - into the Control Source field.