Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to default the combo box value from the Table?
Versions des environnements
Network:
Windows 2003 Server
Hi,
I have a combobox on a form to select the Warehouse which have the properties as follow:-
Bound To is TRUE
ControlSource is WAREHOUSE.WH_ID
RowSource is WAREHOUSE.WH_ID, WH_NAME
RowSource Type is 6-FIELDS
There are 5 records in the WAREHOUSE table, but I want to default the record
3 as default display value when the form start.
The Combobox display sort by following order.
WH_ID WH_NAME
1 Warehouse A
2 Warehouse B
3 Warehouse C
4 Warehouse D
5 Warehouse E
I try put the LOCATE FOR... command in the INIT event of the combobox, but the result not success.
Please advise.
Derek Yim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement