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

 

[Uncle Gizmo]

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.

The first question is do you want to pass just the single selected value in the combobox or do you want to pass the whole list of items displayed in the combobox? I asked that question because that sort of what it looks like you are trying to do with your code...

 

[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.

 

[Uncle Gizmo]

I don't think this is the particular answer to your particular question, and actually I'm not 100% sure I've got your question down Pat yet. But I thought you might like to have a look at some ideas on my blog here:-


http://www.niftyaccess.com/open-one-form-from-another-and-transfer-data/


which might be of interest to you regarding the process of transferring information from one form to another...

There's loads of different ways of doing it!

 

[Uncle Gizmo]

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.

But what I'm not clear on is "field Based" a field, (a text box) or is it a combo box?

 

[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

 

[Uncle Gizmo]

So are either or both or none of your combobox's bound or unbound? Bound means that the data displayed in the combobox is related to an underlying table.

Unbound means that the control in this case a combobox, but it could well be a text box or some other control. Being unbound means that it doesn't save any information anywhere, not directly anyway...

 

[ivonsurf123]

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

 

[Pat Hartman]

Your code refers to RowSource/RecordSource but you are asking for a field value. I am confused. Can you try again using data to show what you are trying to achieve.

 

[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.