Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
projecttoday
Starting Member
31 Posts |
 Posted - 2010-02-25 : 19:01:16
|
| I have an Access ADP with a form. The form has a stored procedure as its record source. When I open it with acFormadd, enter some data, and DoCmd.RunCommand acCmdSaveRecord it saves the new record. Now I want to open it for modifying a record. I have another openform with a where condition. The where condition in the openform statment doesn't seem to pull up the right record. (The controls on the form are bound.) Is this the wrong approach? |
|
|
projecttoday
Starting Member
31 Posts |
Posted - 2010-02-25 : 22:30:40
|
| I found the Input parameters property on the data tab. I think that's what I need. The question is, will it interfere with the new record call on the same form ... |
 |
|
|
projecttoday
Starting Member
31 Posts |
Posted - 2010-02-26 : 19:54:37
|
| I wasn't able to use the input parameter property in the data tab. Instead I set the value in the on open event of the form. In the case of new records this has to be bypassed. |
|
|
|
|
|
|
Access form with where condition