You can’t typically put a Requery command on a Got Focus or Before Update event for the combo box. All Requery does is reload the recordset with your forms or controls.

According to the error message you’re getting, you should use a double click event for your combo box to open an edit list form. That type of form is best if you’re trying to add a new record to your combo box. The edit list form should Requery the combo box on the main form automatically.

Alex Thank you. The Vendor field is a combo box on the main form. Let me tell you what I am trying to do and maybe you have an answer for me then. If I delete the Got Focus event and double click the field it opens up the vendor form for me to either edit or fill in as a new vendor on a blank form. Once I do that I have to close the main form before that vendor shows up in the droop down list. I put the requery Got focus event in so it would be there without closing the main form every time. Having to close the form every time and reopen it for it to be in the dop down is time consuming. It works as it is if I click to add a new vendor. But if anything is put in that field then double click is when I get the message.

Lee Add this line before the Requery.

If Me.Dirty Then Me.Dirty = False

Kevin, Thank you that seems to work just trying it, I have a lot more records to enter so I will start working with it. I will let you know in a bit. Thank you.

This should add the selected value back to your Combo Box (depending on your setup)

Wow. Kevin, That's way over my head. I will cut and paste it and try that. Thank you..Thank you...so make sure I understand it correctly. This will be the on the Main form I am working in Got focus event on the combo box field? The bold I change to the form that I will be editing. Is that correct?