Right, first off I'm a newbie to Access and this is probably going to be a difficult thing to implement. I've spent 3 days building, learning and researching for a database but I've hit a brick wall. To keep things as simple as possible, I'll use a hypothetical database so as not to confuse things too much with obscure names (I wish more people would do this!)
So let's say I have an inventory table for PC components. Its name is Products.
When the product is selected it must retrieve values for Brand, Component, Model and Price, and automatically populate identical fields on the form. Note that the data on this form must be saved to the Sales table, not the Products table. The Sales form will also have a field for date and quantity sold; allowing me to use reports to keep track of total sales for a specific day, or the number of units sold of a specific component etc. (that bit's straight forward, I know).
That's pretty much the outline of what I need to accomplish. I understand this is a pretty big question
, but I'm hoping you can help assist with the best approach to take and any code I might need.
Cheers,
Winger
Things to note:
So let's say I have an inventory table for PC components. Its name is Products.
- It has 4 fields: Brand, Component, Model and Price.
- I have a form made to enter new products into the inventory quickly.
- This all works perfectly.
When the product is selected it must retrieve values for Brand, Component, Model and Price, and automatically populate identical fields on the form. Note that the data on this form must be saved to the Sales table, not the Products table. The Sales form will also have a field for date and quantity sold; allowing me to use reports to keep track of total sales for a specific day, or the number of units sold of a specific component etc. (that bit's straight forward, I know).
That's pretty much the outline of what I need to accomplish. I understand this is a pretty big question
, but I'm hoping you can help assist with the best approach to take and any code I might need.Cheers,
Winger
Things to note:
- Adding a combo box or list box which fills its list based on a field has proven to be problematic.
- For instance, there may be 100 products belonging to a single brand. The combo box will list the brand name 100 times rather than just once.
- As a result, this just won't work for a product selector.
Last edited:
If anything, I thought formatting would help things to read better lol. 
