Microsoft Access Subform Search Combobox
I am creating a spare part management database in Microsoft Access. I have three tables which are ItemTable, EntryTable and TechnicianTable.
ItemTable has PrimaryKey = ItemID and the value is ItemName.
EntryTable has PrimaryKey = EntryID and ForeignKey of ItemID with lookupwizard.
TechnicianTable has PrimaryKey = TechnicianID and the value is Technician ID.
I need to calculate the stock quantity of each items based on its usage or entries in the EntryTable.
Thus, I have created a Item Stock query that calculates the entries of each item based on "In" or "Out" to calculate the total and group by ItemName. Thus the StockQty field as and expression of Sum(IIf([StatusEntry]='In',1,-1)*[quantity]) AS StockQty.
Now, I want to create a search combobox form based on the Item Stock query to filter the ItemName.
I have created a form with subform. The subform linked to the Item Stock query and the main form has the combobox. In the combobox i have linked the row source to ItemName from ItemTable.
Next I wrote a vba code based on youtube tutorial from here: Access: How to Create Search Form Using Combo box Part 1
When i filter the combobox, the subform is updated which is good but the StockQty column becomes #Name? which i guess is name error and could not find the reference. Is there any solution for this?
To those who are interested, I have solved the problem by following the tutorial in this link!
- SQL string throws "External Name not Defined" error when running in VBA module - Name is defined
- How fast is SQLite compared to Microsoft Access MDB?
- SQL query left join with sum,group by and order by in MS Access
- ms access negative page numbers
- Number of users to a webpage
- How to get an item value from JsonObject
- Microsoft Access and paging large datasets
- Delete VBA module
- Access VBA For Loop throwing error of "No Current Record" after 1 iteration of code
- Splitting a full name string into First, Last and Middle Initial in VBA Access
- Specify Date/Time Field Format through SQL in MS Access
- Implementing Excel VBA code utilising Arrays into Access VBA code utilising Recordsets
- VS 2012.3 Referencing MS Access COM DLL, could not resolve COM reference error
- Add Same Items In ListBox
- how to compare sql server data with MS Access data
- Create a query dynamically
- How can I get TSQL from easy MS Access SQL with little to no handiwork?
- How to refresh an access form
- MS Access - Can't Open Any More Tables
- Specifying Color of Columns in MS Access Histogram Chart
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- How to create custom filter based on user input in MS Access
- Multiple users working from same application through ODBC corrupt ms access DB file. What is wrong?
- How to write criteria for query to return dates a year before current date
- c# Cannot open Database - Windows 10 Access 2016
- How to make a Report title dependent on a parameter?
- How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access
- How do I sort "SELECT INTO" queries that are built on top of each other by their "INTO" / "FROM" table links?
- Access database not closing properly
- How to open form to specific record from datasheet