I don't know how to do that :confused: - I'm just starting out with code :(- I'm just watching videos and trying to emulate what I see is working for others.
I'm looking for some good resources to learn from, but I'm trying to make this work now to start.
Any suggestions ?
So I'm trying to populate a table based on selections I make within a form.
The form is based of a query that pulls a new product category that needs to be added to my first reference table for products.
The form shows all the new unique product codes, and there is a drop down box with...
The cars is just for example. The reality is I could have something come up that's entirely new that I would have no advance knowledge of. When the 5 criteria come together, only then can I determine which category the product belongs to. The five criteria I'm combining may not be consistent...
How/Why = I need to identify the new vehicle with a generic type, because the code that I'm using to identify the vehicle (just for example) is like this :
Record Table: Cypher Table
DOMESTIC - Ford - Fusion - V6 - 2014 = Sedan...
:rolleyes: Yes - it's definitely possible to modify the cypher table manually, but the whole point is to have a form that updates the cypher table based on the excluded record query. The idea is to create a control process that isn't just jumping between tables to copy and paste data.
Howdy All! New to the forum and pretty new to Access (I'm better with Excel).
New job uses a lot of Access - I need help desperately :banghead:
I've got two tables - one that works like a cypher and one with all my records.
I have 2 queries. One that is a simple query that extracts data...