Passing parameters between forms

  • Thread starter Thread starter Simon Webb
  • Start date Start date
S

Simon Webb

I have a form which is used to generate a string.

This string is an SQL query which is the record source for a second form.

Is there a way that I can pass this string from the first form to the second
form when the second form is opened within the first form. At the moment I
use a public variable, but for other reasons I think this is quite a risky
approach.

Thanks in advance

simon
 
Simon,

You can use the OpenArgs argument of the OpenForm method when you open
the second form, and then use code on the Open event of the second form
like this...
Me.RecordSource = Me.OpenArgs
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Help With MS Access 4
Access Invalid bracketing of parameter name 1
Access Passing data from a form to another form! 0
Access Passing the value to a table 1
Excel Export Filtered Form Data To Excel 0
Passing variables between forms? 4
Passing an array parameter to forms Open Event 6

Back
Top