I can "find record" but I cannot edit it without getting an error

[jim35meyers]

I used the Combo Box wizard to find a specific record, and it seems to be working except that when I then try to edit that record and move to the next, it gives me an error saying "Update or CancelUpdate without AddNew or Edit."

We have client IDs, and I am trying to make a box so I can search by client ID and then when their record pops up I can edit it.



thank you for any help

[ranman256]

if the form allows edits, it should work.
if the the query allows it, it should work, UNLESS your query has joins that prevent edits.

[jim35meyers]

Thank you for the response. the form allows edits. do I need to specify that it allows edits in the code? Before I add that combo box I can go from record to record and edit them just fine. When I add the combo box with the wizard it then gives me that error.

[aytee111]

I don't use wizards so I cannot tell what your combobox is doing, but obviously it is causing the problem. Instead, use the combobox as a way for the user to select a value, then filter the form based on that value. You can do that with a macro or with VBA. That takes control away from the wizard and puts it back into your hands.

[Missinglinq]

IF you select the Combobox and go to Properties - Data and look at the Control Source is it blank...or does it have a Field name in it? Comboboxes used for this purpose have to be Unbound, i.e. their Control Sources are empty, or you're actually changing a Field in the current Record when you make a selection from the Combobox.

Linq ;0)>

[jim35meyers]

IF you select the Combobox and go to Properties - Data and look at the Control Source is it blank...or does it have a Field name in it? Comboboxes used for this purpose have to be Unbound, i.e. their Control Sources are empty, or you're actually changing a Field in the current Record when you make a selection from the Combobox.

Linq ;0)>

Thank you, but the box is unbound. It does not have a control source. The weird thing is that it lets me update records through the form just fine, unless I do a SearchForRecord (either using the wizard or just doing it manually). Once a record is brought up on the form, how can I edit it without getting this error?

Thank you

[John_G]

The error message suggests that you have an error in some VBA code in the form. Do you have any code that is attempting to update a recordset? Look for something like .Update (including the leading period).

[Missinglinq]

...the form allows edits...

Are you basing this statement on the fact that AllowEdits is set to Yes or have you actually tried and succeeded in editing a Record on the Form?

Linq ;0)>