searching a subform field

C

cjstudioguy

Thanks for the help...I checked out the site, but I dont
have 3 tables. I only have 2 tables. A customer table
and an Order table. The main form is Customer and the
subform is Order. I don't know what he means by the
third table - "tblProductSupplier, a link table with
ProductID and SupplierID as foreign keys.".

His code uses tblProduct and tblProductSupplier and the
row source for the combo box is tblSupplier...so all 3
tables are apparently necessary for this to work. There
has to be a way to filter the main form based on a field
in the subform, preferably using just the two tables and
two forms that I already have.

Any suggestions?
Thanks
 

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

Unable to display values in 2nd list box from 1st list box selection 2
OpenForm and Navigate to Subform Record? 1
Form design to add data to 3 tables in "Order Entry" style db 1
Allen Browne's "Filtering on a field in the Subform" 3
Filter main form to records with no related records in subform,maintain updateable recordset 4
QBF & Query Malfunction 0
Locked Subform still lets me delete a record 2
Filter Subform 1

Top