I finally figured out how to auto fill a record in forms. YEAH!
Yet I ran into a new problem. Sigh!
tblEmployee holds frmEmployee information.
qrySiteName pulls information from several other tables giving the details of each location.
On frmEmployee, I have it to where when I select the SiteName, and it auto fills in the details of each location based on qrySiteName. Yeah!!!
Problem: Each new record in the frmEmployee has a different SiteName. How do I get each record to hold the information on the auto fill based on the SiteName selected for that record, and save that specific record information on tblEmployee?
MVB:
SiteName Change
Option Compare Database
Private Sub SiteName_Change()
Me.Text104 = Me.SiteName.Column(1)
Me.Text107 = Me.SiteName.Column(3)
Me.Text109 = Me.SiteName.Column(4)
Me.Check111 = Me.SiteName.Column(5)
Me.Check113 = Me.SiteName.Column(6)
Me.Check115 = Me.SiteName.Column(7)
End Sub
Private Sub SiteName_click()
End Sub