Neil
Are you doing like:
Do form QuerySelect to thisform.Criterion?
i.e. Are you using your search modal form to return the value to the main form.?
You do this by issuing "Return ThisFormsCriterion" in the Unload() event of the search form.
I'd recommend using a form property rather than a vatriable. The prop. can be bound to the display field obn the main form. So all you need is:
Do form QuerySelect to thisform.Criterion?
Thisform.Refresh && not even sure you'd need this if bound to form property.
>Sorry Terry I havent explained myself very clearly.
>
>Basically on my main form I call the search form. Then on the search form I select my search criteria which stores this to a variable. Then when I close the search form back to my main form I want the edit box to show the contents of the variable. It does but I have to click on the edit box for it to show, like a refresh problem I think!
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.