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.

 

[Tzokas]

Hi modalman,

why don't use the DLookUp Function... It is very helpful if you want to get or just display the value of a field that isn't in the record source for your form or report.
See Access Help Topics for this.

Good Luck

 

[modalman]

Cheers Tzokas. Works perfect!