Subform Dlookup

[jbedward]

I have successfully written a DLookup in the control source Properties table of a subform when I open the subform directly from the Forms Objects site, but when I open the form and look at the subform at the bottom of the forms page, the DLookup gives me an error. Any ideas would be greatly appreciated! This is the formula if it helps:


=DLookUp("Primary_Price","CDM_test","Charge_Code ='" & Forms!INDY_SUB!CDMwSCD & "'")

[RuralGuy]

SubForms are not listed in the Forms collection, only MainForms. Try:
=DLookUp("Primary_Price","CDM_test","Charge_Code ='" & Me.CDMwSCD & "'")

[jbedward]

thanks for trying, but that didn't work

[RuralGuy]

I assume the Charge_Code is a text field. Does the SubForm still work by itself?

[jbedward]

Yes, Charge_code is text, and the Subform still works.

[RuralGuy]

Is it a specific error or just "#Error"? It should work unless there is something else going on. Any chance of posting a db that exhibits the issue?

[jbedward]

the error is #Error I'm sorry, but I don't know what a db is!

[RuralGuy]

db = Database. Could it be you are getting the error when there are no records in the RecordSource of the form? Can you Compact and Repair and then ZIP up a sample we can play with? It would probably help.