I have a master form with three sub-forms (tabular).  When I enter data to
the sub-form (generated by frmQry_CommitMoneyCat), I would like the data in
the linking field [Project_ID] that resides in the Master form (generated by
frmqry_ProjName_Commit), to populate the ...

My Report currently has a selection of text boxes, that display the
selected option letter, from a list, that's a drop down.  What I want
to do, is to colour the text box with a RED background if the option is
null, and contain a space.  Otherwise I need the background white, with

Hi, I've used combo and list boxes on forms lots of times, but now I'm trying
to run a report I have tied to a query that prompts for a category.  As it is
now, the user has to have a printed list of categories to choose from.  I
want them to select from a listbox when they run ...

I have a report in which there is a bound control (ID) in the group header. I
have put a label in the same section and want it to display text based on the
number in the ID control. I have tried the following and it won't work. I am
not sure at what point in the report loading I ...

Using Access 2003.  Have a screen form with buttons for preview, print, email
etc. for various reports.  I have set all page margins to .7".  Report is
landscape.  After closing and opening database, previewing reports shows that
margins have changed to .25, .253, .066, etc.  ...

This is the code i have in report open event.....
what is the problem...i get "enter parameter " message when run the report
Dim asDB As Database
Dim r1s As Recordset

I call this procedure from the Report_Open event, and am getting the error
shown on the 6th line below.
I'm trying to find out how many records (if any) are in the table
"tblSelectMainReport".

I received help a day or two ago.  I'm still working on the same gas
consumption database I needed help before.  Here's the confusion I'm facing
now:
When I closed the Query and returned to the Report design, Access displayed

I am trying to keep the contents of a text box from splitting over two pages
in a report. I have a large amount of fields in my Report Footer and it's not
practical to set the whole Report Footer section to 'keep together' or 'force
new page' as I want it to flow on straight ...

I have a subform showing records with a Yes/No field. If the field is checked
a macro will append the record to another table.
My problem is that I would like the subform to immediately update after
checking the field but it does it only if I go to another record. If I exit

good day all,
  I have a report that I open from a form, I would like the report to open
full screen as well as in front of my form...
I know this should be simple but I cannot figure it out..

Can I print out just one page. I have a new Avery label and I want to be
sure my report fits perfectly before printing hundreds. How can I print just
one page?

Hello everyone, I am currently working on a database for a local
newspaper to keep track of inserts to be inserted weekly into papers
that go to different post offices. I am having trouble getting the
report to display the way that i want it. I ran a query to gather the

In my report, my data looks something like this:
Group 1 M 10
           F  8
Group 2 M 12

This is the last step in completing my database.  Here are the specifics:
I have a report based on an order form based on table "tOrders".  Some
customers have multiple orders.  I used conditional formatting in my report
to have certain text boxes turn yellow if a customer appears ...