Searching data on a subform

  • Thread starter Chris M via AccessMonster.com
  • Start date
C

Chris M via AccessMonster.com

Hi,

I created a database that has three nested subforms:
Main form: Customers - CustID
First Subform: Project - ProjID
Second Subform: Invoice - InvID
Third Subform: Tasks - TaskID

CustID ProjID InvID TaskID
CustID ProjID InvID

All relationships are one to many. I need to find a Project within a Customer
so that if the ProjID is, say, the fourth for a particular CustID, then that
Project data is what is displayed on the Project subform, not the first
Project entered.
 

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

populate to all rows in the subform 4
building a (relatively simple) data entry form 2
Embedded macro not allowing data entry 1
Linking bound subform to an unbound mainform 1
Requery method for combobox on subform 3
How to convert text boxes on subform into combo boxes 0
Main Form with Subforms 5
filtering a form based on the values of a subform 0

Top