Changing Data Entry value to False to edit records

[Analogkid]

Hope this makes sense.


I have the main form open up where the Data entry is set to YES so it opens in New Field. I created a button to change the value of form's Data Entry to NO. It works. Changed the form so I can navigate through entered fields. I have created a drop down to filter a specific field "Claim#" and it will open that entry. The drop down only works if I set the default form's Data Entry to NO. Dropdown works and I can select Claim#. But if I open the form with DataEntry set to Yes, and I click on the button to change the value to NO, the form changes but the drop down field does not pull up the proper information. The button code is.

Private Sub EditButton_Click()
Form_MainForm.Form.DataEntry = False
End Sub

The Claim drop down has this event after update

Private Sub ClaimSearch_AfterUpdate()
Me.Requery
End Sub

I'm missing something. Like I said, it works without having the button change the value.
Access 2010
Hope this makes sense.
Thank you for your help

[June7]

Try requerying the combobox in the button event.

Me.comboboxname.Requery

[Analogkid]

Thank you June7. But I had a pro on the phone and he fixed it for me. The proper code for the search after update is.
Me.Recordset.FindFirst "[ClaimID]=" & Me.ClaimSearch (the ClaimID is what the query is searching on)

Thank you!

[June7]

I hope that solves your problem. However, I did not get that filtering the form is the issue. I interpreted the issue as the combobox RowSource was not refreshing.

[Analogkid]

That was exactly what I thought that it was the combobox refresh issue. But the code above works like a charm.
Later!