Searching for records when validation rules are used????

[Stan Smith]

I seem to have got myself into a quandry and need some patient advice.
I have a database of telephone calls - there are validation rules in the
properties of the base table to ensure the operators fill in the mandatory
fields ( Call start, county, gender etc).
I now wish to allow them to search this database - my intention was to
enable them to enter just one parameter (for example firstname) - and
retrieve all the records matching that input. Using the same form as they do
for entry but with a Search Command button.
However when I try this I receive an error message that the validation rules
means there must be entries in those validated fields.
Is there any way round this? i.e. keep the validation rules but allow a
search on any field??


Many thanks in advance


Stan

 

[stefan hoffmann]

hi Stan,

However when I try this I receive an error message that the validation rules
means there must be entries in those validated fields.
Is there any way round this? i.e. keep the validation rules but allow a
search on any field??

If you write your search in the normal text fields, you are probably in
an edit or insert state. You have to work around this, when executing
your search, e.g. .Undo on these controls or your form if .Dirty is set.

mfG
--> stefan <--

 

[Stan Smith]

Stefan,
Sorry for delay in responding - been on vacation to get sanity back!!! and
excuse me for using your email address but thought the query might be too
old for you to be watching.
Unfortunately you are talking to a new user in Access so I am afraid I do
not understand what you mean by the Undo and .Dirty.....
Are you able to translate this into really newbie type language???

Many thanks

Stan