populating value of one field to another

[jzacharias]

I am trying automatically populate a field in a subform with the value from the main form. I am trying to track tickets that were written for each month. Each officer works either days,afternoons or midnights on either a yellow shift, red shift or green shift. I don't want to have to manually put in lets say afternoon, red for each record entry. My first attempt worked, but when I changed the shift on the officer table, all the fields in the prior records changed. I need them to remain with the month they were entered. If that makes sense

[NTC]

based on your post I am going to guess that your subform is a continuous form. If so, the issue is this - that subform is an object, and that textbox is a control which has one name. But you have multiple records in that subform. The code can't know which record - so it affects all. This is a fairly common learning experience for developers.

in general - rather than use a trigger event in the main form, instead use a trigger event in the subform. Presuming the user must be entering something into a record in the subform - use that as the trigger point because then you are in a single record and the code will affect only that record.

hope this helps.

[jzacharias]

I don't know what event triggers to use.