record source

[Wes]

When tring to program what the Record Source and Record Source Type I get a blank combobox within the form.

The record Source I want in combo2 when the combo1 = "Accessories" is as follows

The record Source type is Table/Query
The Record Source is table A1

When the combobox1 = "Engines" I want combo2 as follows
record Soucre Type to = "Table/Query"
and Record Source = A2

My code is as follows:

If Combo1.value = "Accessories" then
combo2.recordsourceType = "Table/Query"
combo2.recordsource = "A1"
elseif
combo1.value = "Engines" then
combo2.recordsourceType = "Table/Query"
combo2.recordsource = "A2"

end If

Is there another wasy to go about it?

Wes

 

[Ken Snell]

A combo box does not have a RecordSource property; it has a RowSource
property. You need to change your code so that it uses the right property,
and then you need to requery the combo box after you set the RowSource:

If Combo1.value = "Accessories" then
combo2.RowSourceType = "Table/Query"
combo2.RowSourceType = "A1"
elseif
combo1.value = "Engines" then
combo2.RowSourceType = "Table/Query"
combo2.RowSourceType = "A2"
end If
Combo2.Requery

--
Ken Snell
<MS ACCESS MVP>

When tring to program what the Record Source and Record Source Type I get

a blank combobox within the form.