Combo Box Drop Problem

[rjp99]

I have three combo boxes PC2, AGFND and PCA.
· PC2 drop down list is independent;
· AGFND drop down list depends on the user's PC2 selection and
· PCA drop down list depends on the user's PC2 and AGFND
I have selection queries as row sources behind AGFND and PCA. The query behind AGFND works as intended.

The query behind PCA will not work when I try to pass both the PC2 value and AGFND value from their respective combo boxes. When I attempt this, the PCA drop down list is empty.

When I replace the AGFND combo box reference with an actual value, the PCA combo box produces the desired list.

The database I'm working with is attached and it includes two forms demonstrating the conditions I've described.

I am totally at a loss; I do not understand what's going on with this. Can someone take a look and provide some insight. Thx

 

[Ranman256]

in each combo box, AFTERUPDATE event,
you must refresh the combo, to get the new setting..

cboPC2_afterupdate
cboAFGND.requery
end sub

 

[rjp99]

I put cboAFGND.requery statement in cboPC2_afterupdate sub and in cboAFGND_afterupdate sub and got an 'Object Required' error (424) . Is there anything else I need to do when I use this statement.

 

[leanpilar]

see if the form1_correct is now working?