Form to open on certain record 1

[jmbcreative]

I have a form (HardwareAdd) that opens when a value "addcomponent" is selected within a combo box on a form called "Request". This form (HardwareAdd) has a combo box(System) within it that is querying a table for system names. I need this combo box to auto select the system name that is already selected in a combo box(system) that is on the original form "Request".

Any ideas how to make this happen?

 

[snyperx3]

Wow, I got really confused reading that...but I think i figured it out.

Private Sub Form_Load()
     Me.System.Value = Form_Request.System.Value
End Sub

-Pete

 

[jmbcreative]

Pete to the rescue!

Thanks for the great advice again. I'll learn Visual Basic yet!