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

multiple control sources for a form

P: 98
is it possible for a form to have multiple tables as a control source?
i tried to search the forum, but the search function is not working for me.
Dec 11 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
Depends on what you want to do. When all tables have the same fields it's no problem to switch "dynamically" from using, but in general it's no good idea to do this.

Can you elaborate on the reason why you want this ?

Dec 11 '08 #2

P: 98
i have decided to nix the idea i was working on and instead have the current form open a seperate form, which changes my question.

this is a request database, where there are forms for the clients and forms for the employees that process the request.

then client form generates the unique request tracking number and the employee side calls for the tracking number input to display the information.

these requests can be pended for approval multiple times. I have created a seperate table for storing the request tracking number(foreign key 1 to many) generate a unique pending entry number(primary key) with a pending start date and a pending end date, as well as a comment box for pending reasons.

in addition to the fields, i would like a section to display every pending record for the specific requests tracking number.

have any ideas on any aspect of this request?
Dec 15 '08 #3

Expert 2.5K+
P: 3,072
I guess the best advise I can give is to check the sample databases that come with Access. Just select new database and select the samples tab.
There are multiple samples for tracking all sorts of objects.

Just pick the best fitting form design and use that for your database design..

Dec 16 '08 #4

Post your reply

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