ToffeeMark
New member
- Local time
- Today, 23:01
- Joined
- May 15, 2017
- Messages
- 9
Hi, been using access for a little while but only just started using forms. If anyone has a good tutorial they can point me to that would be great.
One thing I was wondering was, Is it possible to have an option in forms where you can select the table to be used in a query? same query, but just have the table used as a parameter
for example if i have 12 tables, Jan - Dec. Could I give the user an option to compare Jan Vs Dec, or Jun vs Dec etc by selecting the tables from a drop down in the form.
e.g.
SELECT [January].*
FROM [January];
but Instead have something in the spirit of:
SELECT [ "form Select Table Name"].*
FROM [ "form Select Table Name"];
If anyone could point me in the right direction about what terminology I should be searching, I don't might reading around a bit.
Many thanks
One thing I was wondering was, Is it possible to have an option in forms where you can select the table to be used in a query? same query, but just have the table used as a parameter
for example if i have 12 tables, Jan - Dec. Could I give the user an option to compare Jan Vs Dec, or Jun vs Dec etc by selecting the tables from a drop down in the form.
e.g.
SELECT [January].*
FROM [January];
but Instead have something in the spirit of:
SELECT [ "form Select Table Name"].*
FROM [ "form Select Table Name"];
If anyone could point me in the right direction about what terminology I should be searching, I don't might reading around a bit.
Many thanks