Combo Box Problems

[geko]

Hello all, I am having trouble with 3 combo boxes on an unbound form.

A brief background of the database
The database is designed to log calls from members of the public relating to parks, open spaces and leisure centres in the 3 main towns and surrounding areas. In total there are 351 sites (tblSite), 31 towns/villages (tblTown) and 12 site categories, eg. Leisure Park, Open Space etc. (tblSiteCategory).

To make data entry easier I have included 3 combo boxes (cboSiteTown, cboSiteCategory and cboSite) on my unbound form frmCallLog, and the result on each one filters down the possibilities for the next. So, until anything is entered in cboSiteTown there is no list in cboSiteCategory or cboSite, and until something is entered into cboSiteCategory there is no list in cboSite.

This works fine for data entry, but when viewing the records, all 3 combo boxes are empty, even though the results of these are stored in the table (tblCallLog).

Any suggestions on how I can rectify this as it has me

If you need to know more then please let me know.

Many thanks in advance,

G

 

[KenHigg]

I think these are referred to as cascading combo boxes. See if this will help:

Examples

kh

 

[geko]

Many thanks, I'll have a look and a play, then let you know if it solves my problem or not.

Thanks again,

G

 

[geko]

That sample is more or less what I had.

The data source for the 2nd two combo boxes (cboSiteCategory and cboSite) was already set to be dependant upon the initial combo box (cboTown).

I also had the AfterUpdate event on each of the combo boxes, to requery the dependant data source on the other two.

As I said, it works fine for entry, but not when viewing the records later.

Thanks though.

I'm still

 

[Rich]

Why is the form Unbound?