Hi there! My name is***** am a computer professional with over 15 years of experience with both Mac and Windows. It would be my pleasure to help you with this. Would you mind telling me please what version of Access you are using to create the form? Once I know that I can provide detailed instructions.
Thank you for that information. This can definitely be done using lookup tables. I am going to provide a link to a very well written article for you to review as it has illustrations, etc and it would take me quite a bit of time to create a sample table and form. Please click the link below to access the article.
Please give this a try and let me know how it works for you. If you need more help, please let me know so I can continue to assist you.
As a quick and simple example, say that we have have a table named MAIN that contains the Employee lookup field from the Employees table. Also in the employees table is the hourly rate for each employee. We want to set the rate field in the Main table to automatically pull the rate from the Employee table to update when the employee is selected.
There are two different ways that we can do this.
If we just want to display the rate, we can include that field in the RowSource of the Employee combo (eventually with a Width of 0 to hide it). Then,we can bind the Rate control on the form to an expression like
I will opt out in the hopes that another expert will be able to help you with this. Have a good evening!
Hi there, my name is ***** ***** I can help you autopopulate the field. Can you create a zip file of the Access database and attach it to our conversation using the paperclip icon? That way I can look at exactly what you're trying to change and tell you what you need to do to have it behave the way you want.
If you want to have a remote session, I can just do it for you that way. I think they make me charge you an extra $5. Otherwise I can write out instructions that should get you there, but might not be exact because I can't see exactly how your database and form are constructed. Let me know how you'd like to proceed.