gilgameshau
New member
- Local time
- Today, 16:20
- Joined
- Feb 18, 2014
- Messages
- 5
Hello,
I "think" I'm trying to do the same thing as kevin19 and I'm also having trouble. I'm trying to do this in Access 2010 which uses accdb but I've managed to export it to the earlier mdb (which actually eliminated all my calculated fields).
This database is still a work in progress.
In my case I have I have a form frmJobs based upon the table tblJobs.
It has a combo box called cmbFixedPriceJobCode which gets it's values from a table called tblFixedPriceJobs and correctly copies the required value from tblFixedPriceJobs into the correct field of tblJobs.
However there is a second field in the same record in tblFixedPriceJobs that I also want to copy into tblJobs (JobCharge and FixedPrice respectively). This may not follow proper database normalisation practice but I'm allowing for the future where values in tblFixedPriceJobs might change but I don't want historical records in tblJobs to change.
I thought I might use an event procedure on my combo box cmbFixedPriceJobCode so that after a field update some VBA could copy the other field across. But that was where I got unstuck was I'm not aware of the relevant VBA instructions to do this
. VBA may or may not be the best way to do this so I'm open to other methods.
Thank you for any assistance.
I "think" I'm trying to do the same thing as kevin19 and I'm also having trouble. I'm trying to do this in Access 2010 which uses accdb but I've managed to export it to the earlier mdb (which actually eliminated all my calculated fields).
This database is still a work in progress.
In my case I have I have a form frmJobs based upon the table tblJobs.
It has a combo box called cmbFixedPriceJobCode which gets it's values from a table called tblFixedPriceJobs and correctly copies the required value from tblFixedPriceJobs into the correct field of tblJobs.
However there is a second field in the same record in tblFixedPriceJobs that I also want to copy into tblJobs (JobCharge and FixedPrice respectively). This may not follow proper database normalisation practice but I'm allowing for the future where values in tblFixedPriceJobs might change but I don't want historical records in tblJobs to change.
I thought I might use an event procedure on my combo box cmbFixedPriceJobCode so that after a field update some VBA could copy the other field across. But that was where I got unstuck was I'm not aware of the relevant VBA instructions to do this

Thank you for any assistance.