Multiple fields in list box

[Maynard]

I need the same information to pomelgate multiple fields
instead of one field from the list box.
Van Master: VAN NUMBER DEPARTMENT
DATA MASTER: VAN-DEPARTMENT-DESCRIPTION-COST

I want van master as the drop down and a pick off it will
fill van and department in the DATA MASTER.

 

[Larry Linson]

Clarification, please: is a given van identified only by the combination of
van and department (e.g., multiple departments will have a van 1, 2 and 3),
or is van number unique and department only used to show which department is
involved? If the latter, then I suggest you avoid redundant data storage by
simply storing the unique van number and joining the two tables on that
field when you need to use or display it.

If the former, then is your ListBox bound to the Van field in the DataMaster
table? If yes, then include a TextBox control on your form bound to
Department in the AfterUpdate event of the ListBox, put code such as:

Me!txtDepartment = Me!lstChooseVan.Column(1)

Clarify or follow up if I have guessed wrong at what you are looking for.

Larry Linson
Microsoft Access MVP