J
joseph
Good morning all,
I have a data entry form in which I have an "on click" event that performs
an embedded macro to locate a record based on a partial entry of either a
first or last name ... which works perfectly (as I cut/pasted it from the
"Contact Management Database" template from Microsoft). However, I would like
to incorporate a msgbox that advises the user that; for example, they type
"jack" and there are no records in which a last name nor a first name
contains those letters to advise the user that "no records exist" ... I know
about the "if null" event, but that is only for reports. is there a way to
add lines to the embedded macro to provide a msgbox if the results are null?
or must I do it in VBA?
If I must do it in VBA, what event to I place it in?
Thank you
I have a data entry form in which I have an "on click" event that performs
an embedded macro to locate a record based on a partial entry of either a
first or last name ... which works perfectly (as I cut/pasted it from the
"Contact Management Database" template from Microsoft). However, I would like
to incorporate a msgbox that advises the user that; for example, they type
"jack" and there are no records in which a last name nor a first name
contains those letters to advise the user that "no records exist" ... I know
about the "if null" event, but that is only for reports. is there a way to
add lines to the embedded macro to provide a msgbox if the results are null?
or must I do it in VBA?
If I must do it in VBA, what event to I place it in?
Thank you