Hi!
I have a problem with a search form. I'm using a macro to find data from records in two different tables.
First i use goToControl: Control name: search (which is a subform)
Then i use i FindRecord: Match: Any part of field
Match case: No
Search: All
Search as form.: Yes
Only current field: No
Find first: Yes
It only looks in the first row of the table. It doesn't look through to whole table. Don't understand why. I have an older database where this works, and I have compared both databases with eachother but can't find any differens.
please help
I have a problem with a search form. I'm using a macro to find data from records in two different tables.
First i use goToControl: Control name: search (which is a subform)
Then i use i FindRecord: Match: Any part of field
Match case: No
Search: All
Search as form.: Yes
Only current field: No
Find first: Yes
It only looks in the first row of the table. It doesn't look through to whole table. Don't understand why. I have an older database where this works, and I have compared both databases with eachother but can't find any differens.
please help