New Parameter values (from Form) not being picked up by Query

[Guest]

Hi,

I've coded a form which calculates and populates a text box on a form. To
be clear, data entered into the Textbox is not done manually it is calculated
on the AfterUpdate event on other fields in the form.

I have another command button on the same form which then loads a query, the
query refers directly to the "calculated" Textbox on the form as part of the
query's criteria. However the query does not recognise the value entered.
It will work if I click inside the Textbox then run the query!!.

I've tried using Refresh, Requery, DoEvents.... even Repaint... Non seem to
work.

Any help would be greatly appreciated.

Thanks in advance.

 

[[MVP] S.Clark]

What do you mean by clicking the command button 'Loads' the query?
What is the value in the query that should recognize the calculated field?

Post your command button code and the SQL.