Hi,
I have a hand-me-down DB that tracks project data for our company and I need help to push a date entered on one form attached to a table into a different table. My thinking was to add VB code to the "After Update" on the field that would then push the date entered into the Master table record with the same project number. This is bacause the DB was built as several different department specific tables using the ProjectID as a primary key and the frmStatus page is based on the tblMain where all the main data should be kept.
Let's say I have a table called tblReproduction with a date filed called txtCompletionDt, what I need to do is after the date has been entered push a copy of that date over to the tblMaster into the ProjectCompleted field, so it will show up on the reports as a completed project.
It sounds like there should be an easy way to do this in the VBA behind the form, I just can't seem to find a good example?
Thanks....!