If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo boxex, indexing, updating...
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? |
#2
|
|||
|
|||
Combo boxex, indexing, updating...
On Tue, 3 Jun 2008 17:52:01 -0700, Agzmdv
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|