Dlookup returning #Error

[ozziestockton]

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_Vi ew","Account = " & [Forms]![Data Entry Form]![DistrictID])

I have Office 2010, but this database is still an .mdb (could that be a problem?)

Also the table I am linking to is from a dbo connection, so not sure if that might be a problem for some reason.

Thanks for your help!

[help_me_with_access]

=DLookUp("ReportedEnrollment","dbo_Tasb_Account_Vi ew","Account = " & [Forms]![Data Entry Form]![DistrictID])

there's a space in your table name...is that right?

I don't think DLOOKUP is real time. hence, you have to refresh the form if the lookup performed when the record loads IS actually an error.

dlookup is also a terrible function. probably the least favorite of many access developers. It is slow and it's not useful in many scenarios at all. I would code this behind the AFTERUPDATE() event of your drop box. it's one line of code, done. you also don't have to deal with the form's properties. they're not always on your side. sometimes they just plain suck, too.

[RuralGuy]

Is Account Numeric or Text? You are treating it as Numeric.
If it is Text then you will need ","Account = '" & [Forms]![Data Entry Form]![DistrictID] & "'")

[ozziestockton]

Thanks Rural. That fixed it. Now I will see if I can actually get this to write to the table. Thanks again!

[RuralGuy]

Great! Glad we could help.