Populate a field in one form from combobox in another form

[rwmorehead]

I am looking for a quick way to enter data.



I have three basic tables

Master employee table: EEID (primary, Autonumber), employee number, name, date of hire

Education table: EDID (primary, autonumber), type of education, date, notes

Education look-up table: TypeID (primary, autonumber), name of education (i.e. CPR or Orientation)

I have a form create for Master Employee Table, in which we can add new employees.

I want to create a combobox with the look-up values from Education Look-up table. After selecting a class (i.e. CPR), hit a button that would open up a datasheet for the Education Table in which I can enter just the employee name and the date of the education. The type of education would automatically populate from the combobox selection.

I have looked everywhere on the net and looked at many examples, but running into trouble in not finding the right code. Any help would be appreciated. I am somewhat of a novice, so any good code examples would be appreciated.

Ron

[SoftwareMatters]

You can do this on the OnOpen event of your Education datasheet form. Something like this:

Private Sub Form_Open(Cancel As Integer)
If Not IsNull(Forms!EducaitionFormName!EducationFieldName ) Then
Me!TypeFieldName = Forms!EducaitionFormName!EducationFieldName
End If
End Sub