Parameter with query

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I hope I explain this right!
I have a form on which I enter customer transaction
information. Each customer is auto assigned their
customer id.
Have created a combo box that allows me to pick out a
customer and populate their id into the id text box on the
form.
Now, I would like that same customer id to feed into a
query that would appear as a subform (table) on the bottom
of the same form that would bring up that customers
transaction history.
Any help is appreciated!
 
Robert,
Use a subform at the bottom of the form that displays the fields you want
to see, along with "link" CustID field.
Then link the subform to the Main form via the Main CustID (slected by
combo) and the CustID in your subform. The linking (Master/Child properties
of the Main form) will "auto-magically" restrict the records of the subform
to the ones that pertain to the Main CustID.
hth
Al Camp
 
Al,
Thanks so much worked out fine. Actually, I wanted the information pulled
from a subform already on the Main form. ID field on query kept coming back
as ?NAME. I incorporated the query into the first subform and all works
well.....
Now, one more if I may....how can I generate a total for the customer based
on their transactions pulled through the query?
Again, thanks!
 
Back
Top