Event Code

[ladybug via AccessMonster.com]

I have a form called "EmpRpt". It has three fields. First field is
"chrUserID, " this is a combo box with a row source from another table. The
Second Field is "BeginDate. " The Third field is "EndDate."

I then have a command button. I want to put a code in this buttons on click
event. The code should open up a report called "EmpRpt."

The report will have the three fields just like the form. I want those three
fields to appear with the data the user entered in the form. I would also
like this report to open in print preview.

Can someone please help me with a code? Thank you!

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200708/1

[Salad]

ladybug via AccessMonster.c om wrote:

The dates do not come from a table. This is just a form which sets the
criteria that will be used when opening the report.

What help do you need?

Do you need help in creating a report?

Do you need help calling the report?

What do you want to print?

Allen's doing his best to help, I'm confused with your requirements.
You might want to tell us what you have, what you need, whether you are
using a table as the form's recordsource or if there is no recordsource.

>
Salad wrote:

>>>What two tables? There is no table for the dates they are just text fields.

You stated "First field is "chrUserID, " this is a combo box with a row
source from another table..."

So I figured 2 tables were in play. Sometimes combos can have multiple
columns and I figured the data in the combo might be used as well as the
other fields.

>>>>>I have a form called "EmpRpt". It has three fields. First field is
>"chrUserID ," this is a combo box with a row source from another table. The

[quoted text clipped - 28 lines]

>>>> If Me.Dirty then DoCmd.RunComman d acCmdSaveRecord
Docmd.OpenRepor t...

[Bob Quintal]

"ladybug via AccessMonster.c om" <u21071@uwewrot e in
news:76714e6932 a13@uwe:

The dates do not come from a table. This is just a form which
sets the criteria that will be used when opening the report.

Your statement that the form has three fields is what leads
people astray. Forms do NOT have fields. Tables have fields.
The process of binding a form to a table or query means that the
fields appear in the textboxes. Had you said there are three
textboxes on the form, you would have been clear.

As to your problem of the report not opening, your data talks of
chrUserID. is this really a text field, or an ID Number field?
If it's a text field, you need to modify the way you pass the
info to the form
strWhere = "[chrUserId] = " & Me.[chrUserID] will work for a
numeric field.
strWhere = "[chrUserId] = '" & Me.[chrUserID] & "'" is
required for a text type ID.

>
Salad wrote:

>>What two tables? There is no table for the dates they are
just text fields.

You stated "First field is "chrUserID, " this is a combo box
with a row source from another table..."

So I figured 2 tables were in play. Sometimes combos can have
multiple columns and I figured the data in the combo might be
used as well as the other fields.

>>>>>I have a form called "EmpRpt". It has three fields. First
>field is "chrUserID, " this is a combo box with a row source
>from another table. The

[quoted text clipped - 28 lines]

>>> If Me.Dirty then DoCmd.RunComman d acCmdSaveRecord
Docmd.OpenRepor t...

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com