Everybody is good, I want to put the driver inside the driver name, in the car, charging the inside of the form under the driver do a drop-down menu, put into a form inside the driver choose driver's name? Please give advice or comments

CodePudding user response:

"In the design of the car, when the charge registration form", can be specified for field data sources,

CodePudding user response:

Set in the control properties

CodePudding user response:

Have to do is to set up a data source, data source can be directly form the data source table fields, or a SQL query,

CodePudding user response:

The driver table design is wrong, you put your name to fill into the fields,
Can design a "ID" field, automatic numbering, primary key,
Add a "name" field, and then fill in the names in the data table as the picture,
In the data attribute of the combo box, type line source for the table/query, set the driver table line source, source control is set to "name" field,
Or use vba, in the form of "load" event, written statements behind Me. Controls. RowSource="select distinct names from the driver table"

CodePudding user response:

Control properties of line source as the "table/query", source control to specify a table name,

CodePudding user response:

Use the combo box wizard to do

CodePudding user response:

The driver table design is wrong, also should be similar to the
The driver gonghaowu
The driver name
Id
Driving license no
.
This design fields,
Then resize driver controls for the list box, table line source is set to the driver, must pay attention to the binding of listed as 1, the number of columns to 2, column width is set to 0 cm; 1.4 cm, it is ok,
But suggest the original poster to reinforce the Access the basis of the first, the general will have talked about this aspect of the content in the book, belongs to the category of the basic knowledge of Access,

CodePudding user response:

Use the combo box should be ok