how to check if record exists

[MikeT]

Is there a way I can check to see if a record exists in my database without getting a compilation error if it doesn't? I want the user to access the record (as read only)if it exists, and if it doesn't, I want them to recieve a form to input one.

Many Thanks

 

[jaredn]

if(recset.EOF)
{
//show form
}
else
{
//show record
} jared@aauser.com -

http://webfx.eae.net

 

[Nanda]

also check for BOF like (recset.BOF and recset.EOF) = true then there is no record exists.