Ok, easy one for you.. Automatic filling in form.

[Johnnyw]

I have a main form that has a field called "product code" and a button. When I click the button, it opens another form with the details of the "product code." When I fill in the field "product code" on the main form, I want the same code to show up in the details form without me having to retype the same code. Thanks for your help.

 

[Jack Cowley]

In the On Open event of the second form put code similar to this:

Me.ProdCode = [Forms]![FirstFormName]![ProdCodeFieldName]

Do not close the first form or this will not work. If you do close the first form then search help for the OpenArgs argument....

 

[Johnnyw]

Thanks! The code worked but I put it in the on enter event of the Product code field in the second form because when i had it in the on open event of the second form it was giving me an error.