Modify a database similar to Northwind's

FC

Registered User.
Local time
Today, 06:08
Joined
May 30, 2001
Messages
13
Hello all,
I hope someone can help me with this question. I have a database set up similar to the frmCombo1 that is in Northwind's sample database. However, instead of using a list box, I would like to use a subform. The idea being the user will select options from 2 combo boxes and the subform returns all rows of data the match the options. Then the user can make any updates/changes that are needed to these items (pricing changes, etc). Does anyone know what code changes I can make to have this work with a subform? Thanks for your help!
 
Can do

Make a form (Form1 for this example) with two combo boxes (ComboBox1 & 2)
Set the control source to your fields in the table

Make a query with the two fields from the table and the criteria being [Forms]![Form1]![ComboBox1] & [Forms]![Form1]![ComboBox2]
Save the query
Open your form in design view, and drag the query from the database window onto the form.
It will create a sub form based on the query. Mine is called sfrmQuery1

Set the After_Update event for each of the combo boxes to: Forms!Form1!sfrmQuery1.Requery

[This message has been edited by rich.barry (edited 09-11-2001).]
 

Users who are viewing this thread

Back
Top Bottom