View Single Post
  #2  
Old May 16th, 2006, 11:50 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default how to open second form and display first forms information

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.