Form with Custom report

M

micropc

Hello,
Can anyone tell me if it is possible to create a a form that requires client
information and then once that information is complete, I would like to then
create a "report" with some prefilled information and then once I click a
button on the form the information will be inserted where I specify on the
report for printing. I also want to ensure that creating this report won't
impede my information in the form from going into my table so that I can
later generate a client report based on all of the information I have entered
i to the form. Can any one help??

Thank you!
C-
 
G

Gina Whipp

Answers inline....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

micropc said:
Hello,
Can anyone tell me if it is possible to create a a form that requires
client
information
Yes

and then once that information is complete, I would like to then
create a "report" with some prefilled information

Okay, that can be done...
and then once I click a
button on the form the information will be inserted where I specify on the
report for printing.

Since you will be creating the report you can specifiy where and how you
want the information displayed.
I also want to ensure that creating this report won't
impede my information in the form from going into my table

Once entered in your form it is actually going straight to the table so that
shouldn't be a problem...
so that I can
later generate a client report based on all of the information I have
entered
i to the form.

See above about reports...

Can any one help??

What is it you want help with? Tables, forms or reports? What have you
done so far?
 
T

Tom van Stiphout

On Fri, 23 Jan 2009 19:19:00 -0800, micropc

See comments in-line.
Hello, Hi!
Can anyone tell me if it is possible to create a a form that requires client
information Yes.

and then once that information is complete, I would like to then
create a "report" with some prefilled information Yes.

and then once I click a
button on the form the information will be inserted where I specify on the
report for printing. Yes.

I also want to ensure that creating this report won't
impede my information in the form from going into my table
The data would (should) already be in the table by the time your
report runs, because the report draws its data from the table (NOT
from the form).
e.g.:
Me.Dirty = False 'Save the current record
DoCmd.OpenReport "myReport",acViewPreview,,"myPrimaryKey=" &
Me.myPrimaryKeyControl
(of course you replace myObjectNames with yours)
so that I can
later generate a client report based on all of the information I have entered
i to the form. Can any one help??

Thank you!
C-

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top