Pass values to form

[jwillet1]

I have a database of experimental products. The database allows test technicians to input test information as well as product information (obviously in separate tables). Therefore before a tech logs test information, they have to first make sure the test product is in the database. They can do this by looking up the products that are in the database, and if the current one isn't they can input its information. In the lookup section you can also click on an individual product and lookup its test history.

What I am looking to do is add a button in the product information screen that allows the tech to open the test information input form with the test product information already loaded into the form. The product information portion of the test input form, is two combo boxes, one indicates the test products group and the other is the product number.

Looking up information on Google looks like i might need to use the OpenArgs function, however I have never used that before, so any information on that could be helpful as well.

 

[pbaldy]

Sounds like this might work, perhaps adapted for two fields:

http://www.baldyweb.com/wherecondition.htm

 

[jwillet1]

I use that function to open the specific products, however what I want to do is open the test data entry form to a new record and have the group and product code automatically filled in based on the product page i was on.

And I tried the solution on that page it didn't seem to work, the data entry form would open just fine but all the boxes would be blank. I already checked and there is no on open or load code in the data entry form that would blank those out.

 

[pbaldy]

Ah, so OpenArgs would be one solution. I have an example of passing 2 values:

http://www.baldyweb.com/OpenArgs.htm

You could also open the form in data entry mode and then pass the values:

Forms!SecondFormName.ControlName = Me.ControlName