N
Netadmin
Is it possible to get some code that works for a search
form in access 2002. I have a form called RequisitionFrm
with a field called FormID. On my search form I have a
command button called search, and a text box were users
enters the formid number. What I would like is once they
enter a formID number and hit the search button, that it
would display that form, if they don't enter an exiting
formid number or a wrong number it would display a error
message indicating that the formid they entered isn't
valid or nonexsistent and clear the text field for a new
ID number. Also when they enter a exsisting formID and
the form exsist, it would display the form and close the
search form.
form in access 2002. I have a form called RequisitionFrm
with a field called FormID. On my search form I have a
command button called search, and a text box were users
enters the formid number. What I would like is once they
enter a formID number and hit the search button, that it
would display that form, if they don't enter an exiting
formid number or a wrong number it would display a error
message indicating that the formid they entered isn't
valid or nonexsistent and clear the text field for a new
ID number. Also when they enter a exsisting formID and
the form exsist, it would display the form and close the
search form.