control in subform needs value from control in another subform - on same form

[123seven]

Hi


I have a main form with 2 subforms both having a fk of EmployeeID. I'd like to have to only select an employee one time from a combo box on the first form and have the bound integer value copied to the second EmployeeID control on the 2nd subform.

I've tried, as per this forum the following code in the onload event of the 2nd subform:

Me!EmployeeID = Forms![frmShowEntries]![subfShowEntriesDetail].Form![cmbEmployee]

'where [cmbEmployee] is the name of the control, also tried it as [EmployeeID], the field it is bound to...not sure what i'm suppose to reference but in either case I don't get any results in the 2nd form.

I've also tried the same code in the OnFocus event since i thought maybe the problem was that the subform is already loaded, in either case - nadda.

Any guidance would be appreciated

[orange]

site for info on referencing forms and subforms
http://access.mvps.org/access/forms/frm0031.htm

[123seven]

Thank you Orange, but that is exactly where I got the reference logic for what I currently have that doesn't work. I started there with this code:


Me![EmployeeID] = Me.Parent![subfShowEntriesDetail].Form![EmployeeID] or
Me![EmployeeID] = Me.Parent![subfShowEntriesDetail].Form![cmbEmployee]

and got no errors, no changes.

That's when I checked this forum and tried different versions of suggestions.

Is the problem syntax or not being called from the right event, or ??

Thanks, but still help with this...

[orange]

You have a mainForm and 2 subforms -- let's call them subfrm1 and subfrm2.

Which one does this refer to??

select an employee one time from a combo box on the first form

Please describe, using your form names, exactly where you are and what you want to happen.