Multiple Table lookup

External Since: Jul 23, 2008 Posts: 1

I have an database with weekly tables for contributions. I would like
to build a form that will allow users to select the table they want
from a drop down or parameter. I can work with Macros but not so good
with SQL. Is it possible to create a parameter query and link to the
form or a macro which would call for the table?

External Since: Mar 10, 2006 Posts: 123

Make another table and put in it the names of your weeks. Then create a form
for each of your weak tables and use the same name you just put in your weeks
table. Next create a form for them to choose the week, add a dropdown to the
form, name it WeekFilter, and set its conotrol source to your new weeks
table. Add a comand button to your form and call it OpenWeek. In the on
click event of the command button add this code.

Private Sub OpenWeek_Click()
Dim WeekForm As String
WeekForm = Me!WeekFilter

DoCmd.OpenForm WeekForm
End Sub

This will take the value you selected in your dropdown and open the form
with that name.

Hope this helps.
--
Please remember to mark this post as answered if this solves your problem.

"Maria315" wrote:

> I have an database with weekly tables for contributions. I would like
> to build a form that will allow users to select the table they want
> from a drop down or parameter. I can work with Macros but not so good
> with SQL. Is it possible to create a parameter query and link to the
> form or a macro which would call for the table?
>