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

Requery method for combobox on subform 3
building a (relatively simple) data entry form 2
Linking bound subform to an unbound mainform 1
Problem with TreeView on a shared subform 1
Subform based on query 5
Numbering in Subform 1
Set Change Event on Control from Nested Subform 0
Main Form with Subforms 5

Top