msg if form txtbox=identical value in a query field

[aleathiel2005]

Hi all,

I have a textbox (txtBOL) on a formula that i need to prompt a message if the value is the same as one in the list of my query field
(field is [BOL] and query is [merge bol].

Could anyone help me I'm sure it's easy when you know how to use vba correctly

Thanks a lot

 

[Frink]

Hallo,

You need to decide when you want the msg:
When the form is opened, when a record is displayed, when the form is closed, when a field is updated/changed/selected, every 30 seconds

- Frink

 

[aleathiel2005]

On Exit of the textbox

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Frink]

Hallo,

Do you mean when the user enters a new value in the text box, when the user has entered a new value in the text box and then moved the focus to another control, or just when the user moves to another control even if they haven't changed anything?

Is the query displayed on the form (say in a list box)?

PHV's answer's a good-un, but if the data is already displayed on your form and you have a slow network then getting it from the form may well be quicker (although slightly more complicated to code)

- Frink