Query results checking in VB

[Raddy]

I want to add a record through a form, but I have to check if the value already exists on the table. The value composed of a client number and account number.

Now, I can run a query in VB and add the record if the query is unsuccessful i.e. no current records match the record I am trying to add, but how do I check in my code if the query is unsuccessful?

Can I achieve the same using a DLOOKUP?

 

[JamesMcS]

Dlookup would probably be a better way to go, maybe in conjunction with an iserror (Does Dlookup pull back an error with no matches? I forget... maybe it doesn't)

 

[JANR]

Does Dlookup pull back an error with no matches?

Yes it does, use DCOUNT instead.

If Dcount("*", "Table/Query", "Condition") > 0 Then
 ' Record exist

JR

 

[Raddy]

Brilliant!
Many thanks!

(I am from an iSeries background so I am familiar with d/b, but we have access to return codes to detremin the results of operations)