Check for an existing record based on two fields (1 Viewer)

[Chrism2]

Hi there,

Is there a way to check for an existing record (by dlookup, or otherwise) before inserting a new record?

I have a table [tblActCouseElements] with two fields; one numeric, called courseID and one text, called element

My form allows someone to select from a list of options, which in turn does an SQL insert into the above table. The possible selections are based in the left subform, the actual selections on the right (see db attached)

I just want to prevent someone clicking, and adding twice...

What's best here?

Thanks!

 

[pbaldy]

Sure; you can use a DCount():

If DCount(...) = 0 Then
'go ahead and add

http://www.mvps.org/access/general/gen0018.htm

 

[Chrism2]

Thanks! That link was most useful.

Appreciated.