basing sequential combo boxes

[hockey8837]

I have a form in which I'd like 3 combo boxes to be based of one-another. My 3 combo boxes are:
cboFunding--> primary combo box
cboDate-->based off of cboFunding, this box may contain "dates" or "seasons"; i.e. it's not strictly a 'date' box with a date picker, it's a text box.
cboZip-->based off cboDate

I've followed the directions from http://office.microsoft.com/en-us/a...combo-box-on-another-HA001173058.aspx?redir=0

All three combo boxes are based off of qryFundingAndTargetDate.

I have the after update event on cboFunding to be:

Private Sub cboFunding_AfterUpdate()
     Me.cboDate = Null
  Me.cboDate.Requery
  Me.cboDate = Me.cboDate.ItemData(0)
End Sub

The record source for cboDate is:

SELECT DISTINCT qryFundingAndTarget.ProjectFunding, qryFundingAndTarget.TargetPlantingDate FROM qryFundingAndTarget WHERE (((qryFundingAndTarget.ProjectFunding)=[Forms]![sbfnewtreesform]![cboFunding]));

This sequence works, as when I select the funding, the dates change in cboDate, however, I cannot select any of the possible dates. When I select, the box still appears blank. I haven't moved on to work on the cboZip until I am able to select dates from cboDate.

Suggestions?

 

[Uncle Gizmo]

I wondered if this thread could offer some inspiration.

allow-a-combo-box-to-return