Combo box issue

[kryten]

Hi everyone,

I have a combo box from which you can select customer details. My problem is this - If you select a customer from the list it fills in the customer details automatically, however if you then change your mind and select a different customer from the list you get this error:

"Run-time error 3331, to make changes to this field you must first save the record"

If I changed my mind about which customer I have selected I don't want to save the record!

Hope someone can help, thanks in advance.

 

[tjcinnamon]

I'm having the same problem. Does anyone have a resolution to this issue?

Thanks, JOe K.

 

[tjcinnamon]

Here is an example DB of what the problem is exactly.

If you change the Vendor in the Combo box next to the date, it will change as it's supposed to. If you then change it again you will get the runtime error 3331.

However, if you press shift-enter (saving the record) before changing the combo box for the second time you will not get an error. Is there a work around (sendkeys(shift-enter) on enter) or is there a problem with my design.

Your analysis and help is greatly appreciated,

JOe K.

View attachment PO Database.zip

 

[tjcinnamon]

I figured it out. So I'm posting my solution. In my VBA code I used DoCmd.RunCommand (acCmdSaveRecord) after update. It got rid of my error message.