Modify records via form

[AndeanWayne]

I have a form in Access 2007 where the record is selected by a combo box. The combo box is based on a query and selects the desired field (Property ID) as well as other fields from the query. Two fields, date redeemed and amount redeemed are filled in when the proper Property ID is selected. These three fields Prop ID, date redeemed and amt redeemed complete a record for a table Enter Redemptions. This table is part of the structure of the query for the combo box and the other fields are filled in through calculations in the query. So, you dynamically enter data and see the results of the entry. Now I want to have a form to modify the data if necessary. The problem is I get an error that the form is trying to duplicate the primary field (Property ID). In this case I don't want the form to create a new record but simply modify and existing record. Any ideas?

 

[boblarson]

1. The form doesn't have its Data Entry property set to YES does it? (it should be NO)
2. How are you currently trying to open the form to edit the record?

 

[AndeanWayne]

Bob,good to hear from you. You helped me a ton when I was doing Access development in 2003 a few years ago. The Data Entry property for this form is set to NO. Not excactly sure what you mean by trying to open it but it is opened from a control button on a menu page. It opens fine but insists on creating a new record with an existing PropID (primary key) rather than editing the record I select.

 

[boblarson]

Bob,good to hear from you. You helped me a ton when I was doing Access development in 2003 a few years ago. The Data Entry property for this form is set to NO. Not excactly sure what you mean by trying to open it but it is opened from a control button on a menu page. It opens fine but insists on creating a new record with an existing PropID (primary key) rather than editing the record I select.

Post the code you are using to open the form (the whole procedure please).