Default Values in a form

[handjor]

How can I fill multiple items in a form with values based on a previous selection in a form? For instance, If I select an item in an inventory, how would I make the price of the item automatically fill later in the form?

See image below. If I enter the red circled field. How can the Blue circled field fill from the employee_fk id in the employee table?

[desibabu90]

When you design your combo box you have select multiple columns to store the value associated with your employee_fk. In the properties u can just change the value of the following columns to 0" to hide the values.

Then in the after update you can push your data by:

Me.costcode= Me.[Employee Combo].Column(n). n stands for the column number that value is in the combo box. Note that the column increment starts at 0.

[handjor]

Perfect that worked excellently.

[desibabu90]

Great! And welcome to access forums! im relatively new here as well and people here are very helpful!