ozziestockton
New member
- Local time
- Yesterday, 21:37
- Joined
- Jul 19, 2012
- Messages
- 2
I'm new to forms and am revamping a company database. it's a small database and i just want to populate enrollment automatically after the user selects a school district from a drop down. Enrollment is just in another table, so it seems like it should be easy, but I can't figure it out. I get #Error in the text box. I've googled to death with no fix.
This is what I have in the Control Source:
=DLookUp("ReportedEnrollment","dbo_Tasb_Account_View","Account = " & [Forms]![Data Entry Form]![DistrictID])
I have Office 2010, but this database is still an .mdb (could that be a problem?)
Thanks for your help!
This is what I have in the Control Source:
=DLookUp("ReportedEnrollment","dbo_Tasb_Account_View","Account = " & [Forms]![Data Entry Form]![DistrictID])
I have Office 2010, but this database is still an .mdb (could that be a problem?)
Thanks for your help!