Cascading Combo - HELP!!!

[ajh2014]

Master SS 3.zip

I'm trying to build a cascading combo box on my frmCheck_In_Out. I want to be able to type in the Asset ID in the combo box and then have the next combo box, located between asset ID and Status ID, auto populate with the asset type. This database was built by ssnafu and myself. I've searched through the forums to find a function to do this, but everything I find utilizes lookups which I am avoiding at all costs. Thanks!

[ranman256]

Every time you pick a value in a combo, you should REQUERY the next combo , so it gets the new value

cboAsset_afterupdate()
cboBox2.requery
end sub

The query attached to cboBox2 should use cboAsset in its criteria.

[ajh2014]

What query should I make and how do I base it off the cboAsset?

[ssanfu]

I'm kinda backed up, but I'll look at it as soon as I can...

[June7]

Need to know that cascading comboboxes with lookup alias in continuous or datasheet form won't work nice.

[ranman256]

cboAssets.recordsource = qsAssets

cboStatus .recordsource = qsStatus1Asset

qry : qsStatus1Asset has the criteria looking at the form
[asset] = forms!frmEntry!cboAssets


you then requery the combo everytime the cboAsset value changes to get new listing.