I've been through the tutorial for this and I've tried applying it to my database and it almost works but not quite.
i have 2 combo boxes, cboPrgrp and cboSupplier. cboPrgrp is supposed to populate once a selection is made for cboSupplier. When a selection is made in cboSupplier and I click the dropdown box for cboPrgrp, it will prompt me saying whatever the selection is in cboSupplier. If I type in what was selected in cboSupplier, then cboPrgrp will populate properly. My question is why is it prompting me?
Here is the code to populate cboPrgrp:
Expand|Select|Wrap|Line Numbers
- Private Sub cboSupplier_AfterUpdate()
- With Me![cboPrgrp]
- .RowSource = " "
- .RowSource = "SELECT DISTINCT [COMCOD] " & _
- "FROM dbo_ICI1 " & _
- "WHERE [SUPPLR] =" & Me!cboSupplier
- .Requery
- End With
- End Sub
Anybody know why it's prompting me?