Combo Box

[jim]

Is ther a way to have a combo box look up a record in a different table and
fill in the client nem on a form? Here is the example.... I want the box to
fill in the client name on a quote form that will be used to fill another
table. It keeps asking me for the company name in the quote table.

 

[Jeanette Cunningham]

Assuming that the ID for company name is a field in the recordsource in the
form.
The combo needs to be bound to the field for company nameID.
The rowsource for the combo is a query with the company name ID, the company
name and any other fields that are needed to restrict the rowsource to valid
company names for the record shown in the form. Make the query for the
rowsource have its first column the company name ID. Make the combo's first
column hidden by setting its column width to 0cm. Make the column for
company name approx 4cm and make any other columns width 0.
The settings for the combo are like this.
No of columns 2 ( or more if you added extra columns to its query)
Column widths 0cm;4cm - if 2 columns
0cm;4cm;0cm - if 3 columns
Make sure the width of the combo is wider than 4cm
Set the bound column of the combo to 1
Set limit to list to Yes

Jeanette Cunningham