Opening of another form based on data

June 20, 2011 at 15:08:15
Specs: Windows 7
Okay, so I have a real simple problem..

I have a form that displays records, but they need to be locked. I want to create a button that will open the master input form, load the record, and have the user to be able to edit it.

Usually the button in Access 2010 will work in this case, however, its not and I need to know how to do this. I have tried a command like the one below, but its incorrect because of the "where" clause. Any help anyone?

DoCmd.OpenForm "Master", acPreview = acWindowNormal where Combo293.Value = me!forms!expiring[text2]

I know my coding is off..


See More: Opening of another form based on data

Report •

July 3, 2011 at 17:22:01
Here's a list of parameters for the Access OpenForm method

Report •
Related Solutions

Ask Question