Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating main form from subform 1

Status
Not open for further replies.

ajking

Technical User
Aug 13, 2002
229
I have a main form which has a button to open a sub form. this subform has a listbox which allows multiselection of items. I have a variable that holds the resulting string.
what I want is that when I close the sub form I want this variable to populate a text box on the mainform so that the choices are included in the main record.
I am probably missing something very simple but it's one of those days! TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980
 
Before closing the "subform":
Forms![main form]![text box] = ResultingString

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Thanks for the prompt reply! Brilliant! As I said, simple but it's one of those days!

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top