How can I base an Unbound box on a query 2

[JamesBBB]

Hi All

This may be a very simple question, or maybe not quite so easy.

Please forgive me, if I am overlooking something really obvious.

Basically, I wanted to know if an unbound box on a form could have a control source of a query result.

I have a form that has a control source of Books, which has a number of fields, however I wanted to display some count results from totally seperate queries.

These queries I am trying to bind to the box only have one figure in them, a count.

I have tried using expressions such as:-

[TEXT0]
ControlSource = [issuecount]![countofF1]

or

ControlSource = [queries]![issuecount]![countofF1]

but they just throw up errors.

Can anyone please help me on this

Many thanks

James

 

[PWise]

dcount("*","issuecount")

 

[lars7]

Maybe something like this:

=DLookup("FieldName","QueryName")

in the control source of a control.

 

[JamesBBB]

Thanks Guys

I really appreciate the very quick repsonses, I'll test them out this evening when I get back from work.

thanks again

Cheers

James