Printing one form

November 26, 2012 5:56 PM

Access - trying to get by with the easiest way. There's a form and a table. After the form is filled out it needs to be printed and go to the table. Going to the table is fine. The problem - if the exact sequence of clicks is not followed then you print all the forms. Macro? Other ideas?
posted by notned to Computers & Internet (2 answers total)

Response by poster: I found this. Continuing to work the problem.
posted by notned at 6:45 PM on November 26, 2012

Easiest solution is to register the entry's unique ID and use a piece of vba or a macro to open the report using a where clause like "clientID=" & me!ClientID

(I guess this is already solved but I was. Spired by the meta talk thread to look at older, unanswered ask mefi's :-) )
posted by IAr at 1:49 PM on December 31, 2012