CODEWITHSUNDEEP
sqldatabasems-access
Sabre
Sabre

Reputation: 2400

Ms Access 2007 ComboBox

I am using Access for a quick and dirty (ADP) interface for an SQL (Express 2012) database so data entry can begin before the MVC web app interface is complete.

There is one field I want to be varchar, I would like this field to either allow the user to type in a value or select from a distinct list of values previously used in that field.

I have that part down, but the problem is when it happens, I have to refresh the recordset to see the new item in the list, so if they choose add a new record, then the last item added is not visible in the list.

So I can get the distinct list, populate the box, allow for new entry, and save that to the DB, do I have to write a code behind to repopulate the recordset, do I need to write a code behind to maintain the list paralleled to the recordset, or is there just a property I am missing?

Thanks

(Added screen showing event)enter image description here

Upvotes: 1

Views: 201

Answers (2)

Sabre
Sabre

Reputation: 2400

As suggested, using the on current event on the form and the after update solved the problem.

Clicking the form section detail selected the detail sections property page not the form. Selecting the form from the drop down on the property page displayed the events I was suggested to use.

Many thanks to those contributing.

As the first suggestion of this was from Remau, with assist in locating that event from hansup, I will mark remau's post as answer. Thank you to both.

Upvotes: 1

Fionnuala
Fionnuala

Reputation: 91306

Don't requery the form, just requery the combo. The best bet is probably the current event which will work if more than one person is doing data entry. It will also work if people are editing the table as well as entering data. Events that only fire when a record is added will not pick up changes to the combo contents.

Private Sub Form_Current()
   Me.MyCombo.Requery
End Sub

Upvotes: 0

Related Questions