How do I pass values from fields when opening other form

[k_c_morrissey]

I have a subform with two combo boxes. These boxes select product catagory and products. The main form sets the supplier from which to select products.

If the user can not find the product they require they can double click thje product combo, which opens the product input form

I need the Products Form to be automatically populated by the following info:
Products catagory - from combo on sub form
Supplier name/id form parent form.

How do I make this work and/or pass these values as parameters to the products form.

I'm still floundering around with Access and I am stuggling!!
Thx.
Kev

 

[pono1]

Kev,

You can pass a string value to a form when opening it using the OpenArgs property. Search on OpenArgs in Help and in this forum for examples.

You can also pass the data in a control on one form to another form's control using code similar to this.

Me.TextBoxName = Forms!FrmName.ComboName

Regards,
Tim