Action based on a value in an unbound table 1

[reg999]

...need help coding this, I'm very new to VBA coding.

I have a button control on a form that needs to perform an action based on the value of a field in a table that is not bound to the form.

Access table name is "Match" field name is "Mtc" (Text field). All values in the "Mtc" field are the same (expected value is "3StateD1").

How do I refer to the table/field, and write the If?

If xxxxxxxxx Then
DoCmd.OpenForm "test"
Else
DoCmd.DeleteObject acTable, "Match"
End If

Thank you,
Reg999

 

[PHV]

Have a look at the DLookUp function:
If DLookUp("Mtc", "Match") = "3StateD1" Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[reg999]

ahhhhh... how the simple solution eludes me...

Thank you, once again, PHV

I had <U>really</U> tried to make that more difficult...
Reg999