Ive used a wizard to create a search/find record command button.
However when I click on it to find the record, after I type in value(in this case surname) I get the following pop up in a error message.
The value you entered isnt valid for this field.
For example you may have entered text in a numeric field or a number that is larger than the field size settings permitted.
and yet when I click ok on the error message my database displays the record I asked it to search for
Ive been and had a look at the table and all the fields are correctly set up for what they need to display eg text,number so Im guessing I have a form problem. Does anyone have any ideas?
Thanks
However when I click on it to find the record, after I type in value(in this case surname) I get the following pop up in a error message.
The value you entered isnt valid for this field.
For example you may have entered text in a numeric field or a number that is larger than the field size settings permitted.
and yet when I click ok on the error message my database displays the record I asked it to search for
Ive been and had a look at the table and all the fields are correctly set up for what they need to display eg text,number so Im guessing I have a form problem. Does anyone have any ideas?Thanks
