Find Funtion not working
Posted on 2011-10-09
I am using the ‘Find’ function in my project. This function works well in my master form but falls over in any child form where it the child form is opened with the following:
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
The issue, I have found from research on the web, is with the ‘acDialog’ argument.
The error I am getting is as follows:
“The command or action ‘Find’ isn’t available now”
It is rumoured that the problem is the code which opens the recordset which needs changing it to use dbOpenDynaset which is necessary on linked Access tables.
Indeed my project does use linked Access tables and it is in forms bound to these linked tables that I have the issue.
When the forms were just popup and before they were changed to ‘dialog’ the find function worked. So I suppose it’s a combination of ‘dialog’ forms and linked Access tables?
Whatever – does anybody know how to fix the issue with the Find function please and preferably without reverting to popup forms which are more difficult to position on screen in relation to other forms.