I would love to post all my code for someone to take a llok at but I don't own it so I will have to describe it as best I can

Using Access 2k: I have a main form [frmSwitchboard] with a subform [frmCompanyandProduct] (which, in turn, has a couple of subforms of its own).

Both forms are bound to the Main Table [tblCompany_Listing] but are not linked to eachother by any form of filter or child/master link. They are working seperatly (I checked this). The recordsets are very simple and are just an 'ORDER BY'ed list of all the companies without any criteria

In the Subform there is an unbound combobox (this is necessary) which is populated with the names of the companies and their internal IDs.

There are 22 Companies in the main table at this stage. when the forms are loaded, the frmSwitchboard shows 22 records but the frmCompanyandProducts shows just one! And always the same one! I have checked and checked and there is nothing that I can see to make this one record any different to the others.

When I open the frmCompanyandProducts form on its own, it shows all 22 records.

What am I doing wrong??!?!?!?!?!?!11??!??/111!!1//!?!?

I know that from this description it is VERY hard to make any sort of judgement but if you have come accross this before, PLEASE let me know how you sorted it. It's doing my head right in