dlookup to search for matching criteria when record exists

[rhinomac]

I am trying to verify that a field (assignment)in a record matches an existing criteria (BREAK-FIX) in an if statement.
I am using a dlookup to take the existing record that is not the primary key and if the criteria matches then continue with the statement and open a form if not then msg box.
heres a sample of the code:

If not IsNull (DLookup "[assignment]", "dbo_problemm1", "[assignment] = '" + "BREAK-FIX" + "'&quot) Then

DoCmd.OpenForm "hotswapevent", , , "[number] = '" & Me![number] & "'"

Else

MsgBox "Problem Ticket is not a Break fix, Please enter another Ticket.", 48
Me!number.SetFocus


End If

 

[rhinomac]

Also if anybody knows any good references for dlookup function that i could use please let me know...

 

[Frink]

Hallo,

The access help facility describes DLookup pretty well, IMHO.

Making loads of assumtions, is this what you want to do?

dim strNumber as String

strNumber=Nz(DLookup("number","dbo_problemm1","assignment='BREAK-FIX'"),"")
if strNumber <> &quot;&quot; then
  DoCmd.OpenForm &quot;hotswapevent&quot;, , , &quot;[number] = '&quot; & strNumber & &quot;'&quot;
Else
  MsgBox &quot;Problem Ticket is not a Break fix, Please enter another Ticket.&quot;, 48
  Me!number.SetFocus
end if

If that's not what you wanted to do then can you give some more info?

- Frink