Error Message: The object doesn't contain the Automation object 'qryQ.'.

[Bipsy]

ControlSource is now=[Me].[ServRate]=DLookUp("ServRate","qryQ","Service='" & [Me].[OrdService] & "'")
When I open Form1 the ServRate box is already containing #Name in it.


I don't understand what wrong I am doing.
My humble apologies to all you who are trying to help me if I am wasting your time.

[June7]

The ControlSource would not include =[Me].[ServRate]. And Me. can only be used in VBA.

=DLookUp("ServRate","qryQ","Service='" & [OrdService] & "'")

[Bipsy]

Ma'am. Truly grateful to you from the very bottom of my heart. What a star you are!!
Its works perfect. My humble apologies I missed to answer your questions.

Thanks a million to you and all others who tried to help me.
Please bear with me as I am a very new on here - joined only today.
I am a retired bookkeeper working on Access only as a hobby to kill my time as I find it very fascinating.
Cheers all. God bless you all.

[orange]

Glad you have a solution and welcome to the forum.

As for

Please bear with me as I am a very new on here - joined only today.
I am a retired bookkeeper working on Access only as a hobby to kill my time as I find it very fascinating.
Cheers all.

Google can be your best friend. You can search for terminology and examples. You'll be surprised how much self-learning results from reviewing a few examples.