Another Query Problem...

[music_al]

In a previous post, someone told me that I could refer to a query field from a text box on a form.

The query I have ALWAYS returns just one record, so I am referring to a field in that query record via the Control Source with...

=[Appt Query]![Score1]

but it wont work. Why ??


Thanks in advance

Al

 

[boblarson]

In a previous post, someone told me that I could refer to a query field from a text box on a form.

The query I have ALWAYS returns just one record, so I am referring to a field in that query record via the Control Source with...

=[Appt Query]![Score1]

but it wont work. Why ??

Because whoever told you that is out of their mind???

You really can't do that. You need a DLookup or a field from the form's recordset.

 

[pbaldy]

You would only be able to get the value if the form was bound to that query. Otherwise, try a DLookup:

=DLookup("Score1", "[Appt Query]")

 

[Scooterbug]

I believe that you can only reference a query field if the form is bound to that query. I'm guessing that the query you are trying to reference isn't part of the that.

You can do a dlookup on the query if necessary.

 

[music_al]

I tried Pbaldy's suggestion and it worked fine.

Thanks you

I love this site