how do i get command button to print one form?

jgclemens

New member
Local time
Today, 17:45
Joined
Aug 5, 2011
Messages
4
so what i'm TRYING to do is have a user select one location (table linked to excel spreadsheet), add some info (po#, # of packages) and print (only that form). so i made a form with a combo box, user selects location, then the location info populates into appropriate fields. added a few text boxes so the user can input order info. added a command button to print only form selected but when i click print it prints all records. where am i going wrong (besides the obvious of having little knowledge of access)?
 
Forms are in general used to allow users to interact with the data stored in the underlying tables. If you need to display or print a representation of that data you should look at using a report to do that. In this case you could use a query based on the current record being displayed in your form to populate a Report.
 

Users who are viewing this thread

Back
Top Bottom