Query on Page

[Rebel7]

Hi Guys,

I want to build a query where I have a page with a textbox and button and when I click on the button the query runs that looks at the value entered in the textbox and then looks it up against a table that I have and advises the user if that value exists or not with a pop up message. If no value is entered, a popup box appears asking the user to enter a value.

Thanks for your help.

 

[Rebel7]

Just for clarification I am using the Pages module to design this.

 

[neileg]

I'd use DCount() to look for a match, not a query. 0 will mean no match, 1 will mean the data exists.

 

[Rebel7]

Can you please elaborate?

Thanks

 

[neileg]

You need to see if the user entered value already exists. So if you count the number of times that value occurs in the data, you'll either get 1 or 0. So you need to write some VBA that uses DCount and then branches two different ways depending on the count.