By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Many Queries to feed one Form, How?

P: 3
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.
Sep 3 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 2,653
Hi, rdb.

Post the query calculating current stock of a specific tool part.
Sep 3 '07 #2

P: 3
Thanks FishVal.
Really appreciated.
I have managed to do it using VB code.
But, I'm still amateur. So, if there is any problem again, I'd like to ask all the experts here including FishVal.

Sep 12 '07 #3

Expert 2.5K+
P: 2,653
You are welcome.
Glad that you've managed to solve the problem.
Good luck.
Sep 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.