Add a field to an already created report

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

I am a complete idiot to MS Access. I used the Inventory
Wizard to try and set up a new database. My report is
half way there, but it doesn't seem like the report screen
is connecting to the table and form screen information.
How do I get these to show up on my reports?
 
HI Nicole!!

If you're having problem with adding a new field to a
report make sure that in the textbox properties of this
new field that you've entered something in the Control
Source of this object. It needs to have a reference to the
new field otherwise it doesn't know where the information
is comming from.

So if you have something written in the control source,
And its still not working, his your report perhaps
connected to a query, if so, you need to add that new
field inside the SELECT Clause of that query. OtherWise,
it doesn't know what your refering to.

If that's not working, his this report connected to a
table where the new field doesn't exist. Then you must
create-it in design mode( for the table in question) and
insert ,in view mode, a few lines of data for testing
purpuses.

The bottom line is, when creating the report always make
sure that the table will always have all the desired fields
(columns) that you require before starting the Report
Wizard.

This should give you a few things to check for.
Hope this helps,

Patrick
 
Nicole said:
I am a complete idiot to MS Access. I used the Inventory
Wizard to try and set up a new database. My report is
half way there, but it doesn't seem like the report screen
is connecting to the table and form screen information.
How do I get these to show up on my reports?
Click to expand...
 
Back
Top