Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
File: ...\Samples\Solution\Forms\Datalook.scx
This sample illustrates providing users with a set of values, selected from another table, in a list box and in a drop-down list box. The value the user chooses is stored in the current table.
It is often more convenient for a user to choose from a list of predetermined values, and, of course, you minimize the risk that the user will mistype a value. Setting a few list box properties is all that is required to provide this capability. For example, the following properties were set for cboEmp_id on the Using Combo Box page:
| Property | Setting |
|---|---|
| BoundColumn | 2 |
| ColumnCount | 2 |
| ControlSource | orders.emp_id |
| RowSource | SELECT DISTINCT ALLTRIM( employee.first_name) + " " + ALLTRIM( employee.last_name) , EMP_ID FROM employee INTO CURSOR cEmpCombo ORDER BY first_name |
| RowSourceType | 3 – SQL Statement |
Rather than having the user choose an employee id number from the drop-down list, the SELECT statement makes it possible for you to show the user the employees' first and last names.
Because the SELECT statement creates a cursor, code in the Destroy event closes the cursor.
IF USED("cEmpCombo") THEN
USE IN cEmpCombo
ENDIF