A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to open second form and display first forms information



 
 
Thread Tools Display Modes
  #1  
Old May 16th, 2006, 04:05 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default how to open second form and display first forms information

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.
  #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.



  #3  
Old May 16th, 2006, 09:25 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default how to open second form and display first forms information

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.

"Arvin Meyer [MVP]" wrote:

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.




  #4  
Old May 16th, 2006, 09:38 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default how to open second form and display first forms information

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.

"Debba" wrote:

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.

"Arvin Meyer [MVP]" wrote:

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.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Controls disappear from Data Entry form Paul Ponzelli Using Forms 10 February 26th, 2006 06:51 AM
Date range on reports Mark_Milly Setting Up & Running Reports 10 January 19th, 2006 04:49 PM
FORMS: Open New Form, Show data from Previous Employee franklinbukoski General Discussion 1 November 8th, 2005 02:40 AM
Query Only Creent Record? Hulk Running & Setting Up Queries 10 January 25th, 2005 07:39 PM
open a form through a subform in access 2000 Tammy Setting Up & Running Reports 12 October 22nd, 2004 02:43 PM


All times are GMT +1. The time now is 10:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.