Returning data in a second subform based on first subform current

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a customers form in which I want 2 subforms, I already have 1
subform called CustomerSubform which has CustomerID, CustomerFirstName, and
CustomerLastName in datasheet view. What I want to do is create a second
datasheet subform in the main customers form which will display all of the
appointment records for the customer record currently selected in
CustomerSubform. I have been able to make a query which will display all
appointments after being prompted for the CustomerID, however I can't seem to
figure out how to link the current selected CustomerID in CustomerSubform
with the query.

Any Ideas?

Thanks,

Adam
 
Back
Top