E
Edward G
Okay, maybe someone can help me with this experiment.
Let Access 97 create an Order Entry Database with a Wizard.
Select the check box for allowing sample data and just keep hitting next
till the database opens.
Create a new form in design view based on the Customers table.
Start by selecting the Tab Control on the Toolbox and create a tab. (You
will automatically have two tabs.)
On the second tab use the Subform tool to insert a pre-existing subform
"Orders by Customer Subform". Accept the default SQL statement for which
records to show.
On the first tab use the Toolbox to add a List box. In the list box wizard
you want the list box to find records on your form, this is choice 3.
Select Company Name as the field to show in your list box. Click Next till
you finish.
Open the form and select Rattlesnake Canyon Grocery from the list and check
Page 2. The records in the subform will be numbered 11 thru 15.
Select any date on the subform and hit the Filter by Selection button.
Now remove the filter.
The records on the subform are now numbered 1 thru 5 and belong to Let's
Stop and Shop. But Rattlesnake Canyon Grocery is still selected on your List
Box.
What code would you add to make the records revert to 11 thru 15 when you
remove the filter?
Thanks for your indulgence.
Let Access 97 create an Order Entry Database with a Wizard.
Select the check box for allowing sample data and just keep hitting next
till the database opens.
Create a new form in design view based on the Customers table.
Start by selecting the Tab Control on the Toolbox and create a tab. (You
will automatically have two tabs.)
On the second tab use the Subform tool to insert a pre-existing subform
"Orders by Customer Subform". Accept the default SQL statement for which
records to show.
On the first tab use the Toolbox to add a List box. In the list box wizard
you want the list box to find records on your form, this is choice 3.
Select Company Name as the field to show in your list box. Click Next till
you finish.
Open the form and select Rattlesnake Canyon Grocery from the list and check
Page 2. The records in the subform will be numbered 11 thru 15.
Select any date on the subform and hit the Filter by Selection button.
Now remove the filter.
The records on the subform are now numbered 1 thru 5 and belong to Let's
Stop and Shop. But Rattlesnake Canyon Grocery is still selected on your List
Box.
What code would you add to make the records revert to 11 thru 15 when you
remove the filter?
Thanks for your indulgence.