I am trying to use the dmin function in access 95, but I seem to get the error messages that says compile error due to the macro or expression. I made a command button that has the expression below for event. I want to go to a record that has the INSURED field blank, with no entries. The numbering system is preset with values that I have chosen. (no autonumbering)
The code I am using is
Macro1 = DMin("[INSURED]", "PAPolicyBind", "[LINE OF BUSINESS] = 'Mass'")
where
Macro1 = macro that goes to record on a specified form. (GoTo on record space)
INSURED = the field I am searching
PAPolicyBind = the table I am searching
LINE OF BUSINESS = a field I am using to have the search return a NULL value. (Since Mass will never be in that field).
Any idea what I am missing here?
Thanks
Enrico
The code I am using is
Macro1 = DMin("[INSURED]", "PAPolicyBind", "[LINE OF BUSINESS] = 'Mass'")
where
Macro1 = macro that goes to record on a specified form. (GoTo on record space)
INSURED = the field I am searching
PAPolicyBind = the table I am searching
LINE OF BUSINESS = a field I am using to have the search return a NULL value. (Since Mass will never be in that field).
Any idea what I am missing here?
Thanks
Enrico
