populating a listbox with values dependent on a combo box selection

[ronmon]

Have a hell of a mornign this morning. What i wuold like to do this time is to have a listbox populated with information depending on a value selected in a combo box any ideas anyone

 

[PHV]

Take a look in the FAQ area.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ronmon]

i have checked out the FAQ on populating a combo box but it doesn't seem to be working i can get it working when i use a text box to decide the 2nd combo box selection but it just won't work with the first combo box

this is my rowsource for the second combo


SELECT asset_table.Asset_tag, asset_table.Name FROM asset_table WHERE (((asset_table.Model)=[forms]![form1]![cmbmodel])) ORDER BY asset_table.Name;

can anyone help

 

[PHV]

Is the BoundColumn of cmbmodel the Model one ?
If asset_table.Model is not a numeric field you have to enclose the cmbmodel value inside single quotes in the WHERE clause.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884