This issue has been driving me bananas so if someone could help I would really appreciate it!!!
I have created a database to track sales. I have 3 tables: "Transactions" "Transaction Details" and "Products". The setup is very similar to the orders entry sample database. What I am having problems with is that I want to have a combo box list the product name and price per unit. I built a query for my product ID combo box that includes the fields: Product ID, Product Name, and Unit Price. When the combo box is opened it shows two columns: product name and unit price.
I am trying to set up this box so that when an entry is selected, the unit price is automatically updated from the combo box to the unit price text box next to it. This is necessary to prevent error. I have seen this type of operation done in the orders entry sample database in Access '97 but I can't for the life of me figure out how they do it.
Also... My knowledge of Access is limited at best (especially when it comes to macros and VBA) so if anyone has an idea to help please break it down to the very basics, or babysteps... (I know this is time consuming but I'm a real rookie
)
Thanks in advance...
"The Rookie"
I have created a database to track sales. I have 3 tables: "Transactions" "Transaction Details" and "Products". The setup is very similar to the orders entry sample database. What I am having problems with is that I want to have a combo box list the product name and price per unit. I built a query for my product ID combo box that includes the fields: Product ID, Product Name, and Unit Price. When the combo box is opened it shows two columns: product name and unit price.
I am trying to set up this box so that when an entry is selected, the unit price is automatically updated from the combo box to the unit price text box next to it. This is necessary to prevent error. I have seen this type of operation done in the orders entry sample database in Access '97 but I can't for the life of me figure out how they do it.
Also... My knowledge of Access is limited at best (especially when it comes to macros and VBA) so if anyone has an idea to help please break it down to the very basics, or babysteps... (I know this is time consuming but I'm a real rookie
Thanks in advance...
"The Rookie"