button on form

[Guest]

I have a form that has a field called Vendor_Nbr. I have a button on this
form that generates a mailing label (rpt based on a query) when clicked.

What I need to happen is to allow the user to click the button on the form
and print a mailing label for the vendor_id (current record displayed on the
form) without having to enter the vendor id when prompted by the query. Is
there a way to do this? How can I have the Vendor_Nbr on the form
automatically be used as the Vendor_Nbr in the search criteria for the
mailing label report?


Thanks!

 

[Barry Gilbert]

In the criteria row in your query, replace your current prompt with:
Forms!MyFormName!Vendor_Nbr

HTH,
Barry

 

[Barry Gilbert]

In the criteria in your query replace [Enter vendor Id] with
Forms!MyFormName!Vendor_Nbr

HTH,
Barry

 

[Guest]

Thanks Barry! It worked!