Fill in Form fields based on combo box from another form

[kegoosse]

Hello,

My situation is the following:

I have 2 forms (Form A and B). Form A contains a combo box, and a command button that opens form B.

Question:

What VBA code should I use for the command button in order to fill 1 field from form B with the selection from the combo box in form A?


I know what to do when I remain within 1 form, but it's the first time I'm trying this with 2 forms. Probably very simple, but I can't find the solution.

Thanks in advance for any help
Kenneth

[Bulzie]

Few ways to do that. In the OnOpen Event of Form2, add:

Me.Field1 = Forms!Form1!Combobox1

Field1 is the field on Form2. Change the names of the forms and fields to your actual names.

[kegoosse]

Thanks. Was not familiar with the OnOpen Event.

Problem solved!