changing defaults on acEditMenu, acRelectRecord

[Rokerone]

Hi
I am using docmd.doMenuItem, aceditmenu, acselectrecord on a form. What I would like to do is set the 'Look in' and 'match' properties. I would like the defaults to be - Look in = the entire table and not a field name and 'Match' = any part of the field. Is it possible to change the defaults or not? I first of all tried docmd.findrecord which was what I initially wanted to do but I received an error message telling me that it was no longer available. I am using Access 2000. can any one help me?
Thanks
Jane

 

[Van T. Dinh]

1. Try not to use DoCmd.DoMenuItem. DoMenuItem is based on the Access95
Menu which is a fair bit different from Menus of later Access version. If
you look at the argument, you specify "Edit/SelectRecord(s)" but it looks
like you got "Edit/Find". In fact, Microsoft have been saying that
DoMenuItem is available only for backward compatibility. You can use the
RunCommand (with new/different arguments) in stead of DoMenuItem.

2. To set the Defaults for the Find Dialog, see:

http://msdn.microsoft.com/library/techart/acglobaloptions.htm

--
HTH
Van T. Dinh
MVP (Access)

Hi
I am using docmd.doMenuItem, aceditmenu, acselectrecord on a form. What I

would like to do is set the 'Look in' and 'match' properties. I would like
the defaults to be - Look in = the entire table and not a field name and
'Match' = any part of the field. Is it possible to change the defaults or
not? I first of all tried docmd.findrecord which was what I initially wanted
to do but I received an error message telling me that it was no longer
available. I am using Access 2000. can any one help me?