reference a value on a form from another form

[ivonsurf123]

Hello,

I am trying to pass a value from one form (comboBox) to another form (ComboBox) where the value is on frm_BankHolidays and the combobox that I need to add that value from the other form is Based, the form name is frm_Register_New_Employee. I am not sure if I am using a wrong reference and /or the wrong event as well. Please help.

Private Sub Form_Load()
     Me.Based.RowSource = [Forms]![frm_BankHolidays]![cboCountry].[RecordSource]
   
End Sub

 

[ivonsurf123]

What I want to do is everytime I enter a new value in cboCountry to also add it in the other field Based that is in the other form.

 

[ivonsurf123]

Based is a ComboBox from the form that I want to add the value that I enter in the other ComboBox cboCountry which is in frm_BankHolidays

 

[ivonsurf123]

Sorry Just realize that Combobox Based is under a navigation Form as well

 

[MajP]

Agree with everyone. What is unclear is if a user selects
"Germany" in cboCountry on frm_BankHoliday do you want to set the value of combobox "Based" to "Germany" or do you want to add it as a selection to the row source of combobox Based.

FYI. Forms have recordsources combos and listboxes have rowsources.

 

[ivonsurf123]

Hello Everyone,

Just figure our how to do it, just silly of me, I was complicated myself, sorry about that, all I just need to do is to reference the table BankHolidays in the property sheet (Data = Row Source) of the New Employee form and that was it. Thank you for all your help.