I created a Macro named AutoExec to open my form in FilterByForm mode. Has to be named AutoExec so it runs when you open the database. Here's the macro.
RunMenuCommand
Command FilterByForm
RunMenuCommand
Command ToggleFilter
StopMacro
I hope this helps.
Roger
I've created a form to edit my database. When you open the database, the form opens and in FilterByForm mode. A user enters a part number, then selects ToggleFilter. All the records for that part number are selected. I have a macro that is suppose to allow the user to enter the next part...
Hey everyone! My name is Roger and I am fairly new to Microsoft Access. I had to learn Access about 4 months ago, to convert a Lotus Notes database to an Access database. I'm here to hopefully find answers to some problems I am having.
Thanks,
Roger