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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |