open one form if record exists open another if doesn't

[tizwaz]

I have a form called frmSupplier in which if you double click the supplier ID it opens a 2nd form showing all the contracts awarded to the supplier. What I would like to do is if there are no contracts awarded to the supplier instead of opening a blank form open a 2nd form showing the contracts which the supplier has tendered for but not been successful. The supplierID is the same for both tables.

How can I write the code to say if no record exists in the 1st table check the 2nd and open a different form?

 

[PHV]

Have a look at the DLookUp (or DCount) functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tizwaz]

I'm not really familiar with these functions - how would I use it in this situation?

 

[PHV]

No F1 key on your keyboard ?