Store data from a dropdown in 2 or more fields

[SusanK4305]

I have a cbo box [cboPosition] that looks up its values (off of [tblPosition])and then stores that select item in a nother field in [Main Log]field[Position].

Question is:
How can I get cboPosition to store the selected data in 2 fields [Main Log][Position]and in [Applicant Additional Info][Position]?

[SusanK4305]

Ok, never mind, I think I will just do an Update SQL for this.
However If any one knows and would like to post it any ways that is fine by me.
Thank You!

[MMcCarthy]

In the after update event of cboPosition you could run an update query to update the second table. However, you should be careful of any structure that has the same value being stored in two different tables. This indicates a problem with your overall structure.

[SusanK4305]

I wish I didn't have to have this field however I need the data for a report and the table the data is currently on will not run w/ the report. so that is why I need my field to update in to their field.