Combo boxex, indexing, updating...

[Agzmdv]

I have a "Combo/List" box to quickly pull records by clients account number.
When I use it to access records, it works fine by populating the fields in
the form. If I add records, they do not appear in the combo box unless I
save, then exit the the data base file. Also, the combo box pull down does
not keep the records in alpha-numeric order after using it to pull records.
Any suggestions to keeping the "index" sorted and updated as records are
added?

 

[John W. Vinson]

I have a "Combo/List" box to quickly pull records by clients account number.
When I use it to access records, it works fine by populating the fields in
the form. If I add records, they do not appear in the combo box unless I
save, then exit the the data base file.

Requery the combo box in the AfterUpdate event of whatever form you're using
to add new records. If you're adding records directly in the table... don't.
Table datasheets aren't designed for data interaction.

Also, the combo box pull down does
not keep the records in alpha-numeric order after using it to pull records.
Any suggestions to keeping the "index" sorted and updated as records are
added?

Base the Combo on a Query sorting the records in the order you want, rather
than directly on the table.