How to ignore data in a table

[anishkgt]

Hi,

I have a data entry form for which one of the field needs to be ignored when entering data but when doing so the error returns saying " You must enter a value <some table>"


is there anyway to ignore this field when needed ?

 

[jdraw]

It appears that the field in the underlying table has the "REQUIRED" attribute set to YES.
You may have to review the table's structure and see if it OK to not have an entry.

 

[anishkgt]

i thought that was the issue but that was set to NO already.

 

[anishkgt]

Yea there was one more table that had to be changed to NO missed that . now its ok.

Now does anyone know how create search form such that the records are filtered as they are typed in the form fields. I know its possible with vba was hoping to learn it through macro, if there is a way

 

[sneuberg]

I've attached an example of search while you type. It has vba in the change event but it's not very complicated. I think this would be difficult to do in a macro.

 

[anishkgt]

Well that is quite simple and more understandable. what about multiple fields ? Thanks would this be possible in macro?

 

[sneuberg]

Sorry don't know about that. I suggest you start a new thread with a title that reflects your needs.