Access 2003 Linking Data

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
*
 
Back
Top