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!Contr olName
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
"Debba" wrote in message
...
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.