I just want to thank you for your brilliant answer to my question on populating my reports to a combo box on my form. It works very well.
I also have a problem with my dlookup. I have developed an entry form with a combo box it containing a list of school codes. I would like to populate other details from the school table to the fields on the form for data entry purpose. This is what I have so far but is not working:
Expand|Select|Wrap|Line Numbers
- Me.SName = DLookup("[SchoolName]", "tblSchools", "[cboSchoolCode]='" & Me.[cboSchoolCode] & "'")
Expand|Select|Wrap|Line Numbers
- Me.txtCounty = DLookup("[County]", "tblSchools", "[cboSchoolCode]='" & Me.[cboSchoolCode] & "'")
Thanks for your assistance.
Oscar