Verifying number exists in query

[Dirk_Bob]

I have an edit form that I open after some one enters the appropriate NC#.
How do I validate if that number exists before opening the edit form?

 

[Lance]

if dcount("[NC# Field]","[TABLE WITH NC# FIELD]",[NC# FIELD] = [WHATEVER
NUMBER]) > 0 then..else..end if

 

[Dirk_Bob]

Lance,

Thanks, I understand the code. Where should this be placed?
--
Dirk

if dcount("[NC# Field]","[TABLE WITH NC# FIELD]",[NC# FIELD] = [WHATEVER
NUMBER]) > 0 then..else..end if

I have an edit form that I open after some one enters the appropriate NC#.
How do I validate if that number exists before opening the edit form?

 

[Lance]

Try putting it in the afterupdate event of whatever control you're entering
your NC# in.

Lance,

Thanks, I understand the code. Where should this be placed?
--
Dirk

if dcount("[NC# Field]","[TABLE WITH NC# FIELD]",[NC# FIELD] = [WHATEVER
NUMBER]) > 0 then..else..end if

I have an edit form that I open after some one enters the appropriate NC#.
How do I validate if that number exists before opening the edit form?