Cascading Combo boxes that populate but don't fill form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've trawled through this site and many others and can't seem to find out
what I'm doing wrong! I'm a beginner so be gentle!

I've got a form that is linked to a table tblcustomers. I've got 2 combo
boxes, the first has account managers and the second has accounts. (CboMgrs
& CboAccounts). I've successfully filtered the second by what was selected
in the first (yeah!) but this doesn't populate the form?

I've put the combo boxes in the form header, got the allow edits set to yes
and am wondering if it is because my rowsource for CboAccounts is linked to a
query that is pulled from the table (only way I could get the combo boxes to
filter!)

Any help would be greatfully received!!

Kate
 
Kate,
What columns you have in your combo (from left to right), and which
column holds the data you want associated with your table/form field.
Any hidden or 0" width columns?
What number do you have in the BoundColumn property?

A combo, besides having a query behind it, must also be "bound" to a
field in your table if you want you're selection "captured" to the table.
This involves placing that table field name in the ControlSource of your
combobox, and then using the BoundColumn number to properly associate a
column from the combo to be captured to that table field.
Post back with your column info, and I'm sure someone can help solve your
problem.
 
Hi Al

Thanks so much for responding! In my form, the first combo box is 'CboMgrs'
and this is associated with the column 'Manager' in tblCustomers. Second
column is 'CboAccount' and this is associated with column 'Account' in
tblCustomers. No hidden columns and the bound column is 1 for both combo
boxes although the text for them both reads 'unbound'?
Cheers
Kate
 
The Control Source for the each field must be set to the field in the table
that you want that Col1 value stored in.

ex. (use your own table field names)
For cboMgrs, the ControlSource should indicate [Managers]
cboAccount ControlSource should have [Account] enetered there.
 
Thanks Al

Seems to have sorted the problem!!

Kate

Al Camp said:
The Control Source for the each field must be set to the field in the table
that you want that Col1 value stored in.

ex. (use your own table field names)
For cboMgrs, the ControlSource should indicate [Managers]
cboAccount ControlSource should have [Account] enetered there.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Kate said:
Hi Al

Thanks so much for responding! In my form, the first combo box is
'CboMgrs'
and this is associated with the column 'Manager' in tblCustomers. Second
column is 'CboAccount' and this is associated with column 'Account' in
tblCustomers. No hidden columns and the bound column is 1 for both combo
boxes although the text for them both reads 'unbound'?
Cheers
Kate
Click to expand...
Click to expand...
 
Back
Top