Forms to Reports

[salof98]

How do you add new information from a form to a report that is already created?

 

[Dirk Goldgar]

How do you add new information from a form to a report that is already
created?

Do you mean, add fields to the report that you've added to the form? The
form doesn't come into play at all -- you have to open the report in design
view and add the new fields manually. If the report's recordsource is a
query, you may need to modify that query to ensure that it includes the new
fields you (presumably) added to the table.

 

[John W. Vinson]

How do you add new information from a form to a report that is already created?

Reports don't (well, shouldn't) draw information from Forms. They draw
information from Tables. Forms are used to edit the information in the table.

Do you want to add new *FIELDS* to the report? or ne *RECORDS*? If the latter,
no change should be needed, other than perhaps in changing the criteria of the
query upon which the report is based. If new fields are needed, you'll need to
open the Report in design view, change its recordsource to a query including
those fields, and add new textboxes or other controls on the report to display
them.

 

[salof98]

As in Office 2003, when you add infomation in on a form it had checkbox on
the right which printed the information in the form in a report. Is this
better I'm sorry I'm getting the problem from someone else.

 

[John W. Vinson]

As in Office 2003, when you add infomation in on a form it had checkbox on
the right which printed the information in the form in a report. Is this
better I'm sorry I'm getting the problem from someone else.

I'm sorry, I have NO idea what you're talking about here. I use Access2003
(not "Office 2003") all the time, and forms do not magically come with a
"checkbox on the right".

What kind of form do you mean? How was the form created?

 

[salof98]

We're using Office 2007 which includes Word 2007, Excel 2007, Access 2007 and
PowerPoint 2007. Thanks for your input. I need someone that is familiar
with 2007. I didn't mean magically, thanks anyway I would rather deal with
someone that is not so rude.

 

[Dirk Goldgar]

(re-posting, as my original reply hasn't appeared)

We're using Office 2007 which includes Word 2007, Excel 2007, Access 2007
and
PowerPoint 2007. Thanks for your input. I need someone that is familiar
with 2007. I didn't mean magically, thanks anyway I would rather deal
with
someone that is not so rude.

The problem is that we, who are professional Access developers, don't know
what you're talking about. You won't find anyone more knowledgeable about
Access than John Vinson, nor anyone who has spent more time helping people
online for no reward whatsoever. So if he doesn't know what you're talking
about, you may want to consider that you're not describing it well. I don't
think he was rude at all; he was just trying to find out what you mean.

If you want help with this issue, you'll have to try to describe what
you;'re trying to achieve, and what you "used to have" in Access 2003, in
more detail and different words. I've worked with both Access 2003 and
Access 2007 (and Access 95, 97, 2000, and 2002), and I don't recognize your
description of a "checkbox on the right which printed the information in the
form in a report."

 

[salof98]

I found someone that knew what I was talking about and he was rude to me in
the description words and using quotes. If he didn't know what I was talking
about all he had to do was politely post for me to explain better. I found
someone that is more familiar with 2007 since he said he uses 2003. Thanks
to everyone that was polite and helped me.