How do I get a text box to display query results?

[105ben]

Hello,

I have a text box, I have pasted this into the control source:

=[qryIndividualFaultVolumes]

then on a button I have this code:

me.qryIndividualFaultVolumes.requery

However, I get a Method or data member not found error when i click the button? Any idea why?

 

[RainLover]

"qryIndividualFaultVolumes" This should be the Record Source of the Form.

Then the text box needs a Control Source of one of the Fields within the query.

 

[105ben]

Brilliant, working now! Thanks

 

[RainLover]

Glad I could help with that.