can i send values back from a popup form ?

[Ahamedos]

Hi,


in Access i'm able to send data from form to another.
but i'm trying to send data back from a popup form.

in my cenario Original form has a subform to enter products.
when I click in one product it will open a popup form showing some extra information in Datasheet about that Clicked product.
in the popup form I want to click in one option and send it's values back to the original form to Autofill some fields.



is it possible ?

[ranman256]

before the close
run an update query to update the table under the form
or

assign the values manually using full path names:
forms!frm1!txtBox1 = forms!frmPopUp!txtBox1
forms!frm1!txtBox2 = forms!frmPopUp!txtBox2
docmd.close

[Micron]

removed - practically a duplicate response

[pbaldy]

Jason has a sample db here:

http://www.baldyweb.com/WrappedForm.htm

[Ahamedos]

before the close
run an update query to update the table under the form
or

assign the values manually using full path names:
forms!frm1!txtBox1 = forms!frmPopUp!txtBox1
forms!frm1!txtBox2 = forms!frmPopUp!txtBox2
docmd.close

I meant to select from the popup form.
for example the item will be sold as Cartoon or Piece.
if i select Cartoon, I want that row values to be sent back to the invoice form.
and if i select Piece, I want it's raw values to be sent back.

so each time it's gonna be different. and each product have different units (Pieces or kg ,,, etc.)

[Ahamedos]

Jason has a sample db here:

http://www.baldyweb.com/WrappedForm.htm

Great Samples in the website. I'm gonna try Cascading Combo.
Thanks

[pbaldy]

Thanks, I hope it helps. Doesn't seem like what you were after here though.