I'm attempting to get certain fields to show in text boxes, still very new to access.

[tbrewer409]

Carrier.zipI have a combo box made with a list of furnace models. I can get a list of certain coils to show in a list box based on my selection of the furnace model, but cannot get any info to show up in a text box. Any help or criticism is greatly appreciated.

[ranman256]

If you want to filter a single record form on the listModel you pick ,then:

sub lstModel_afterUpdate()
me.filter= "[model]='" & lstModel & "'"
me.filterOn = true 
end sub

[moke123]

try this in your textbox controlsource

=[FurnaceModelComboBox].[Column](2)

You were not referencing the combobox column correctly.

You should also consider getting rid of the Multi valued field. They tend to be a p.i.t.a.

[orange]

A few comments for consideration:

-Every table in a relational database should have a Primary key
-Access field names should not contain embedded spaces nor special characters eg "( )"
-most developers will tell you, as moke123 did, avoid multi valued fields.

Here is a link to database design and planning info that may be helpful to your project.
I recommend you work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the linked info.

Good luck.

[davegri]

Your database structure requires a classic Many-to-Many relationship setup.
Many coils are associated with many furnaces and many furnaces are associated with many coils.

Take a look at this. It replaces your database, having extracted the needed data from the original.
The multivalue field is gone, replaced by a link table in a many-to-many relationship setup between coils and furnaces.

Carrier-davegri-v01.zip

The code in module basConvert does the multivalue field conversion and builds the linking table.
It is included for information only as it should not be run again.