Hi All,
I created a form to show current stock of specific tool part no from one query. The current stock of a specific tool part no = All Purchased Tools - (Tools in Repair if any + Scraped Tools if any). Specific tool part no is chosen from the unbound combo box.
The problem is when a tool has never been repaired, the form goes error. the form can only works when a tool has been repaired. in another words, the form only works when data for all the 3 fields (All Purchased Tools, Tools in Repair, and Scraped Tools) are exist. If one of them is not exist, the form won't work.
I think the solution for this problem is to have 3 queries (one query for All Purchased Tools, one query for Tools in Repair, and one query for Scraped Tools) to feed the form. So, when specific tool part no is chosen in combobox, it should requery all the 3 queries. I don't know how to do this though.
I have created the 3 queries and link them with the combobox using [Forms]![MyForm]![MyCombo] and put "me.requery" in MyCombo afterupdate event. But, It doesn't work. I suspect it's because Record Source of the form (if I look in its properties) is only linked to one query. Please help.