Access 2003 Linking Data

G

Guest

I'm looking to link 2 combo boxes in a Form that will allow:

a) Detail records in a sub-form to be selected from the Main Form Selection
b) Sub-Form records to then be based on a list of categories from a combo-box
c) A second sub-form to be based on the category selected in combo box "b"

It looks like this: StoreNumber then to All Categories Selection then to
results based upon specific Category Selection and Store Selection from Main
Form.
 
S

strive4peace

Hello,

what table is your main form based on?

what table is your first subforms based on?

what table will your second subform be based on?

how do the tables relate?

where are the comboboxes? are they unbound or bound? if bound, what is
the ControlSource? What is the RowSource for each?

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter query on combo box in a continuous subform 0
Cascading Combo Box Selection Being Overwritten 1
changing multiple records with a combo box. 1
Using a combo box as a filter 1
Combo Box Display 3
Displaying all data when using a combo box 6
Limiting Available values in Combo box on form 10
Update combo box in subform (After Update event) 10

Top