Simple referencing question

[kryten]

Hi all,

How do I reference a field in a query from a form?

 

[KenHigg]

Can you be a little more specific about what you are trying to do?

kh

 

[kryten]

Hi Ken,

Thanks for replying.

Basically, I have two queries GoodsIn and GoodsOut which calculate what comes in and what goes out. A third query calculates GoodsIn less GoodsOut and comes up with the OnHand figure.

What I'm trying to do on my form is reference the OnHand figure for the relevant product.

I tried to include the OnHand query as part of the underlying recordset of the form but this makes the form non-updateable.

 

[KenHigg]

Maybe you can get a dlookup() or dcount() function to work? Look them up in vba help if you are unfamiliar with them.

???
kh