Form Combobox not populating related field in table

[Madraykin]

Hi All,



I have a combobox on my form with fields related to it (ie. when an option is chosen in the drop-down, the next two fields are also populated with data based on the selection made - I know this is duplication of data, it's just the way the 'powers that be' wanted it. I'm changing it in my next version of the database!)

The two fields that are populated as a result of the selection in the combobox are migrating into the related table fine, but the actual selection in the combobox isn't - it's showing up as blank in each new record in the table.

Anyone have any ideas why this might be?

I'm still a noob at this, so all of my attempts to work it out have failed

Thanks in advance all

Mads

[Robeen]

Can you go into the Design View for the Table [right click on table and select Design View] and tell us what the data type is for the field that your errant Combo Box is bound to?

[Madraykin]

It's currently set as 'Text'

Sorry if I'm being a real dunce!

[Madraykin]

Ah - I sorted it!!!

[Robeen]

What was the problem? And how did you solve it?