Linked Forms Query

[mcclunyboy]

Probably a common query but I have 1 form and i want to open a 2nd form with 1 text box automatically populated....

I did try google/search but not had luck yet

edit - whats the code to open a form in add mode...i cant find it

 

[pbaldy]

After opening the form, you can have:

Forms!SecondFormName.ControlName = Me.ControlName

If you look at VBA help on OpenForm, specifically the data mode argument, you should find what you need.

 

[mcclunyboy]

has anyone got an example!?