Predictive text - updating/accessing

[AlexanderBB]

I have some combo boxes on a form with their record source set to underlying table
so I can use predictive text for data entry.

However it only works for existing data, any newly entered stuff doesn't show up until the
form is closed and opened again.

Is it possible to use just-entered data from a previous record ? (without closing the Form first)?

 

[HiTechCoach]

Yes. You need to requery the combo box. I use the On Enter event of the combo box.

Example:

Private Sub cboMyCombobox_Enter()
    Me.cboMyCombobox.Requery
End Sub

TIP: While a control has the focus press F9 to requery it.

 

[AlexanderBB]

Thanks very much... a perfect solution
Had it up and working in seconds.

 

[HiTechCoach]

Thanks very much... a perfect solution
Had it up and working in seconds.

You're welcome. Glad we coudl assist.

Ans thanks for the update!