Open Report

[Emma]

I have a form for each of my 1000 members. I have 6 different reports which
link the member to a specific profile group. I have a button on the form that
says preview reoport. This button brings up one of the 6 reports linking to
the producer number. I need help on how to do this. I basically need to say
if the producer number on the form is found on the report then bring up that
report.

I am very new to Sql and things like that. It is probably something simple
but can't get my head around it and would appreciate the help.

Thanks

 

[MikeJohnB]

Hi Emma

Step 1, make a backup of your database and try the following.

One way to do this is to base your report on a query, generate a query with
all the controls on your reports which should include the field Producer
Number.

With the query in design view, right click in the criteria row of the column
[Producer number] and select "Build" use the expression builder to locate
your form and select the control [Producer Number]. Set the report record
source as the query.

Now, when you select the Producer Number on your form, this becomes the
criteria for the reports query so the report will only display that record
that displays the Producer Number.

The criteria should look something like this

[Forms]![YourFormName Here]![YourControlName Here]

I hope this helps you??

Regards
Mike B

PS there may be someone who can point you to a demo of how to do this, if I
find one I will post back.