I have a form with combo boxes created via wizard. I want each combo box list to be limited based on the prior combo box criteria. (except the initial combo box)...
cmbFIRST - from a table
cmbSECOND - from query - field 1; [Forms]![frmDATASHEET]![cmbFIRST]
cmbTHIRD - from query 2 - field 1; [Forms]![frmDATASHEET]![cmbFIRST] field 2; [Forms]![frmDATASHEET]![cmbSECOND]
cmbFOURTH - from query 2 - field 1; [Forms]![frmDATASHEET]![cmbFIRST] field 2; [Forms]![frmDATASHEET]![cmbSECOND]; field 3; [Forms]![frmDATASHEET]![cmbTHIRD].
When I open the queries I am prompted for the criteria... so it is looking for something.
When I close the query and open the form the form shows blank combo lists, the criteria data is entered in the same row.
None of the combo box's based on queries are working - simply showing blank data. The row source points to the correct field in the correct query; example: SELECT [qryONE].[fieldONE] FROM qryONE ORDER BY [fieldONE]
Any thoughts on why the combo box's are not showing any data?
Thank you!!