Find Form in Access XP

[Andy Smith]

I'm having a problem with the Find form in Access XP SP2.

If I open one of my forms from the database window by double clicking
on it and then do Ctrl-F, the find form functions as expected.

If I open the same form in code using
DoCmd.OpenForm "FormName", acNormal, , , ,acWindowNormal
then do Ctrl-F, I can only use the keyboard, when I try and click on
controls with the mouse nothing happens. I can click back to the
original form but cannot get focus back to the find form.

Can anyone shed any light on what is going on.

Thanks
Andy

 

[Arvin Meyer]

Hi Andy,

I could not reproduce that problem even when I set the form to modal yes and
popup to yes. I suspect you have some corruption in that one form. Try some
of the anti-corruption measures at Tony Toews web page.

http://www.granite.ab.ca/access/corruptmdbs.htm

For form corruption I find the SaveAsText code on my website to be
particularly effective.

http://www.datastrat.com/Code/DocDatabase.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Andy Smith]

Hi Arvin,

I think your explanation of a corrupt form is close, this happens on
all the forms in the database that were converted from Access 97 to
XP.

I will try exporting the forms to text files and re-importing as this
fixed a problem we had with converted reports not keeping the printer
settings correctly in XP.

Regards,

Andy