Autocomplete

[kirkm]

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

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

Is there any way around this ? Thanks.

 

[JHB]

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

Is there any way around this ? Thanks.

If it is unknown - how do you want it auto complete then?
Are you thinking of a spellchecker?

 

[kirkm]

> If it is unknown - how do you want it auto complete then?
Perhaps my question should say how to 'make it known'. E.g I enter data into the various fields and click onto the next record. None of the data in the previous record will autocomplete until I close/open the Form (although data entered from previous sessions works OK).

It's not for spellchecking, rather some data is repeated (or is nearly the same) and it saves typing it in again. Except having to close/open the form every time negates any saving.

 

[arnelgp]

try this: http://allenbrowne.com/ser-24.html

 

[spikepl]

The record source of the combo needs to be requeried. If you used the nont in list event it would do it for you, as far as i recall.

 

[kirkm]

Thanks to both of you. The requery method in the Enter event of the combo box did it.