HELP VBA Popup form to Report

[lhanes72]

First time poster. Not proficient VBA user by any means.

Ok, here's my dilemma. I have a popup form with three options. All three options will open the same report; but two of the options will populate different fields and the third option will populate both fields. When one of the buttons is clicked, I want the fields to populate as the report opens and then have the form close.

Please help.

 

[KenHigg]

I would do this with the form openargs property. Search the forum on it and if you still have questions post back -

 

[lhanes72]

Thanks for the help, Ken. I could have searched days looking for that without finding an answer. The sample database explained everything nicely.

 

[KenHigg]

Glad to help - Now you can repay the forum by being the openargs guru -