General information
Category:
Coding, syntax & commands
Title:
How to default the combo box value from the Table?
Environment versions
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only