how to open second form and display first forms information

[Guest]

Ok, I have looked around at the threads and found similar answers but it isnt
working for me. I have a complaint form with peoples names in a combo box
and also a complaint form number which is auto numbered. when a user fills
in the complaint form for somebody i then want a button on this form that
opens the improvement form, for that person (selected in combo box on
complaint form) that the complaint was made about. so the second form which
is the improvement form will display the complaint form number from the
complaint form and the persons name that was selected in the complaint form
combo box. HELP how do i do this - ive tried a few of the answers on this
topic but nothings working.

 

[Arvin Meyer [MVP]]

I would open the second form only from the first and set the DefaultValue of
the controls to the first form:

=Forms!FirstFormName!ControlName

or if it's on a subform:

=Forms!FirstFormName!SubformControlName.Form!ControlName
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks. I have tried that and it works for some boxes on the second form but
not the combo boxes, also I want the second forms information saved to the
improvement form table but it wont if I do it this way, or I dont know how to
get it to save to the table fields.

 

[Guest]

It worked! I tried again and it did work, thankyou very much. I didnt
realise I could put these expressions into the default value property.