Running SELECT statement in VBA

[bishman]

I have an Access form where a user enters a value into a text field. I can get this value through VBA no problem.

However, I want to run a check on this value.

How can I run a SELECT statement in VBA code. What I want to do is the following:

SELECT COUNT(Records) FROM Table WHERE Records = "Value user entered in the form"

Then I need to check if count is zero, and if so, display an error message.

Any ideas?
Many thanks.

 

[TonyJollans]

Hi bishman,

For this use DCOUNT rather than SELECT ..

RecCount = DCOUNT("Records","Table","Records =" & UserInput)

Enjoy,
Tony

 

[bitbuster]

Hello,

To run SQL from code use DoCmd.RunSQL "SQLSTRING".

Regards,

Bitbuster

 

[TonyJollans]

Hi Bitbuster,

RunSQL is for Action queries only (INSERTs, ALTERs etc.), not SELECTs.

Enjoy,
Tony