Forms to Reports

F

Fed Up

How do I create a command button that will find a particluar item on a Form - say Store Name, and have it print to the report that equals that Store Name?
 
G

Graham R Seach

Once you have the appropriate record displayed on the form, issue the
following code:
DoCmd.OpenReport "rptMyReport", acViewPreview, , "[StoreID] = " &
Me!txtStoreID

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Fed Up said:
How do I create a command button that will find a particluar item on a
Form - say Store Name, and have it print to the report that equals that
Store Name?
 

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

Top