Update info text boxes based on combo boxes on data entry forms

[Saracen]

Hello,

I've seen this type of thread already in this forum but I can't find any replies that answer my question:

Put very simply I have two tables e.g "Names" & "Teams".

Names table:
ID_field (primary key), Name_field, Extn_field

Teams table:
TeamID (primary key), Name1_ID, Name2_ID, Task_ID, etc. etc.

I've created a form which I use to create records in the "Teams" table which consist of exactly two records from the "Names" table - two combo boxes draw from the "Names" table (along with other text info). This works fine. Each record in "Teams" table then consists of four fields...simple.

However I get into trouble when I try to display "Name_field" column in a text box below each combo box (for operational clarity when entering records). The combo boxes are working as expected storing IDs etc. into the "Teams" table. The text boxes on form are not working or rather some work some do not. I'm using e.g. [combobox_name].[column](1) as the control source for the text boxes.

The DB (Access2010) is really that simple (at this stage). There are no other dependencies etc. I've tried deleting the offending text boxes and recreating them again from scratch, no go, I've even copyied text boxes that are working, still no go. Very frustrating. Any suggestions would be much appreciated. Thanks.

 

[Saracen]

...Apologies to all readers if this simple problem has been answered in this forum previously. It seems the questions that have previously been asked relate to the actual mechanism required to populate the text boxes, i'm familiar with this (i think) i'm just having trouble implementing it...does that make any sense?

 

[boblarson]

...does that make any sense?

Yep, and have you set the combo's COLUMN COUNT property to the correct number of fields you have in your combo's Row Source? If not, the data won't show up.

 

[Saracen]

Thanks boblarson,
...yeah i set the column count to 3 so that i could see all the columns in the "Names" table when i click on the combo box just so that i could be sure (at this early stage) which record i was selecting; also the column widths are set e.g. 2cm and the only bound column is the (primary key) id field, its very frustrating, i can't remember having this much trouble with earlier versions of access, its probably something very simple/some overlooked property or something, any other ideas?

 

[boblarson]

Well, not sure about what is happening. I work better if I can physically play with it. Any chance you can compact and repair and then zip the file and upload it here?

 

[Saracen]

ok will try, some shifting about to do - DB is on Win7 work system, posting now on personal (i.e. older!) vista system without access2010 installed, so may take a little while. Thanks again.

 

[Saracen]

Well, not sure about what is happening. I work better if I can physically play with it. Any chance you can compact and repair and then zip the file and upload it here?

Thanks for your assistance with this last week, i eventually tracked the problem to properties incorrectly set in the underlying table - just goes to show, very often problems are caused by the most benign of things and Ive learned (not for the first time) how important tables' design is important starting out.

Thanks again