How do I find out if a record exists?

[modalman]

Can anyone deliver me from this seemingly very simple problem? I have created a database application using Access and Form A needs to open either Form B or Form C depending on whether a particualr record exists or not. I have messed about with VB, RunSQL and DoCmd etc. I have also tried to create a recordset but it wont accept 'Dim dbs As Database' and 'Dim rs As Recordset'. I would really appreciate some guiding advice. Many thanks in advance.

 

[jes]

In the VBA screen select Tools->References and set Microsoft DAO 3.5 Objects to True, and then try your Set Dbs, etc.

You'll find that will work.

Have a good'un,

Jes

 

[modalman]

Cheers Jes.