is a value in my table

[blindlemonray]

Hi,

I have some code that enters a set of values into a table, but what I want to do is check to is the value is already in the table so I can avoid it being entered twice.

I thought dlookup might work but it does not seem to do what I need. I don't know whether I am getting the code wrong or dlookup is not what I need. Any suggestions appreciated.

DLookup("[value_code]", "master_client_plan", Me.form_Code)

 

[PHV]

Perhaps something like this:

DLookup("value_code", "master_client_plan", "value_code='" & Me!form_Code & "'")

If value_code is defined as numeric in master_client_plan then get rid of the single quotes.

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