I'm trying to write a macro that runs after data has been entered into a given field on a form. The first line is OpenTable and the second line is SearchForRecord.
While stepping through the macro, the table opens in response to the OpenTable action but on the SearchForRecord action I get the error:
"The object
![Points] isn't open.... Use one of the open actions or methods to open the object so that you can carry out the desired action"
I previously specified the object name to the actual field I would like to search:
![Points]![PointID] - and I got the same error. I have also tried [Points] and [Points]![PointID] - same error.
Any ideas are greatly appreciated!
While stepping through the macro, the table opens in response to the OpenTable action but on the SearchForRecord action I get the error:
"The object
I previously specified the object name to the actual field I would like to search:
Any ideas are greatly appreciated!