macro help needed

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a macro designed that is used in a right mouse click event on a
textbox (PSID) on form1, which is a continuous form. It is a simple GO TO
and it opens up another form, form2, which is a single form. But, I need to
call the following;

Public Sub FindPackingSlip(ByVal slip_number As Long)

so that when form2 opens, it is on the packing slip from the textbox in
form1 that the right click was done on. I get it to work with the exception
of passing in the above info.

If someone is savvy in macros, I can use the help as to how and where to
pass the the info above into.

Thanks.

John
 
Use the Where argument of the OpenForm action in a macro to tell Form2 which
record is to be shown. No need for a "GoTo" nor calling the sub.
 
Ken, thanks for the response. I was able to actually shorten the macro and
function that it was calling and got the results I was was looking for on the
right mouse click. I guess the proverb... "can't see the forest for the
trees" came into play here. Wasn't seeing what was really needed because of
too much code in the way.
John
 
Back
Top