Value from combo box field to assign Yes or No in another field

[and]

Hi,

On a form I have a combo-box field (EthnicityID), bound to Client_table, its values are populated by another table, Ethnicity_type, (fields: EthnicityID, BME), in which for each value of EthnicityID there is a corresponding BME value (yes or no). For each record in my client_table I want to have a column showing BME value that is automatically given a Yes or No value according to to what the user chooses in the combo-box.....

What's the best way to do this?

Thanks,

Andrew.

 

[luceze]

Andrew,

You typically would not store the BME value in your client table since the value is already associated with the EthnicityID in your Ethnicity_Type table. Doing so would create data redundancy.
If I understood your question correctly then the EthninityID is already stored in your Client table. You can create a query with a one to many join on the ethnicityID in both of your tables to display the BME values for later use.

If you really want to store the value in your client table you could do this as one of many options.

Change the row source of your combo to include the BME value. Change the Column Count property to 2. Change the column width property to 1";0". In the after update event of your combo box add this code.

Me.YourBMETextBoxName.Value = Me.cboYourCombo.Column(1)

HTH,
Eric