Advanced Beginner
Windows 10 
Access 2016
I have set up a basic database which records stock in/out and have got a query for stock remaining. The stock is categorised by Stock Category and Stock Description. I now would like to set up a form that uses this query where people could choose from one of the categories and descriptions (have previously used a combo box for these which are related to each other) and it would then have a box that told you how many of this item are remaining? Thank you!
Access Developer
Windows 10 Access 2019
Take a look at at Allen Browne as to say about it: http://allenbrowne.com/AppInventory.html
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Advanced Beginner
Windows 10 Access 2016
hi there, thank you. I already have my database set up with the stock in and out so don't really want to change that. Is there an easier way of creating this form? I don't have any code experience either
Access Developer
Windows 10 Access 2019
Can you post a copy o the db so we can see about your tables.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Does creating a form also create a query?
Posting Permissions
Reply With Quote