Solved Auto populate field in popup FormB with info from field in Main Form

tihmir

Registered User.
Local time
Today, 01:52
Joined
May 1, 2018
Messages
257
I have MainFormA with field name txtCity. With my comand button On Click "New Activity" I open popup FormB and want to add new activity but my txtCity on the FormB want to be auto populate with info from field txtCity in Main Form. How can I do that? Thanks
 
Last edited:
You can fill in any box anywhere,by using the full paths. Use the Builder.
Me.subform.form.txtBox2 = forms!fMainForm!txtBox1
 
You can fill in any box anywhere,by using the full paths. Use the Builder.
Me.subform.form.txtBox2 = forms!fMainForm!txtBox1
Would you give me a little more info command "Me.subform.form.txtBox2 = forms!fMainForm!txtBox1" on the button On Click "New Activity" to be placed ?
 
Last edited:
these aren't commands,
its a simple assignment.

the text box2 in the subform (me.subform) gets the value of the text box1 on the master form (forms!fMainForm)

The BUILDER will give you the correct paths. In a query , click a criteria box, then click the builder button (magic wand with elipsis)
 
I still can not do it :unsure:. Мaybe i can't explain correctly. Here's a Database to explain correctly. When I press the button "New" in Form1, I want the text box City in Form1 automatically to fill City in Form2 (new activity)
 

Attachments

I think there's a bit of confusion here, it's not a sub-form, it's a pop-up form.

Have a look at the video on my website it's the Video in the section named "Open One Form From Another"

 

Users who are viewing this thread

Back
Top Bottom