Returning data in a second subform based on first subform current

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
 

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

Creating Top 10 in linked subform 1
Unremovable horizontal scroll bar on subform 1
Command Button to open form to specific record 2
Highlight rows in a subform datasheet view 0
transfer data from a subform into a table 1
MS Access 2007: Calculated field based on subform: 1
AutoLookup Query subform 4
Subform Won't Show Data 1

Top