VBA? Program Command Button to Open Data Entry Form instead of Report

[zufie]

I have a command button that opens a report.

INSTEAD the end user wants the same command button to open a data
entry form containing essentially the same information as the report
(not open a report, as the report does not allow her to enter data)

Is there a smart way to do this?

I have already tried to change the VBA behind the command button. I
have changed the VBA to open my data entry form, but it fails to do
so.

Naturally, I must have the queries that are behind my report feed into
my form correct?

Or, just create a NEW form from the fields in the report OR create a
form from the query/control source for the report?

As always thanks for your help!

(Zufie) John

 

[fredg]

I have a command button that opens a report.

INSTEAD the end user wants the same command button to open a data
entry form containing essentially the same information as the report
(not open a report, as the report does not allow her to enter data)

Is there a smart way to do this?

I have already tried to change the VBA behind the command button. I
have changed the VBA to open my data entry form, but it fails to do
so.

Naturally, I must have the queries that are behind my report feed into
my form correct?

Or, just create a NEW form from the fields in the report OR create a
form from the query/control source for the report?

As always thanks for your help!

(Zufie) John

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.