Query based on a form page

tmulrooney

Registered User.
Local time
Today, 18:04
Joined
Mar 8, 2002
Messages
23
I have a form that displays account information. AccountName, AccountID, etc. I have attached a subform that displays transactions posted to each accountname. I have a combo box that allows me to retrieve each account and the subform changes to the appropriate transactions for that account. What I am trying to do:

From my form, select an account using my combo box, then have another command button (or whatever) that will take the account I am viewing and query from the transaction table all of there transactions. From this I can make a transaction report and print it based on dates. How do I create a query based on the form I am viewing.

I hope this makes since.

Tim
 
You can reference a field in you query criteria by using
[Forms]![yourform]![yourfield]

Autoeng
 

Users who are viewing this thread

Back
Top Bottom