I start the form by identifying which car# needs to be added to my monthly tracking table, by using a combo box, to pick from Vehicle Table. This works great, and stores car# in the Track Table just fine. But I also want to grab the StaffId field, from the Vehicle Table, for that particular month, and store it emmediately in the Track Table field name called StaffNum. Tried a few things, but still no luck. Thanks StevieBoy

I finally got it.
Easy stuff, but I'm still learning.


Private Sub vehicle_id_AfterUpdate()
Me![TrackStaffId] = Me![VehicleStaffId]
End Sub