Editing a Report

mmcdonal · September 8th, 2006, 10:40 AM

When you click Debug, which line of code is highlighted?

mmcdonal

fubak · September 8th, 2006, 10:40 AM

Quote:

quote:Originally posted by mmcdonal
When you click Debug, which line of code is highlighted?

mmcdonal

The 1st one

mmcdonal · September 8th, 2006, 10:53 AM

Okay, if the first line looks like this:

If IsNull(Me.TextBox1) Or Me.TextBox1 = "" Then

It is wrong unless the text boxes on your form are named "TextBox1"

What are the names of your text boxes? They may be field names.

mmcdonal

fubak · September 8th, 2006, 10:55 AM

Quote:

quote:Originally posted by mmcdonal
Okay, if the first line looks like this:

If IsNull(Me.TextBox1) Or Me.TextBox1 = "" Then

It is wrong unless the text boxes on your form are named "TextBox1"

What are the names of your text boxes? They may be field names.

mmcdonal

My first line looks like this...

If IsNull(Me.CMP_NAME1) Or Me.CMP_NAME11 = "" Then

And those are the names of the textboxes.

fubak · September 8th, 2006, 10:56 AM

Correction...

If IsNull(Me.CMP_NAME1) Or Me.CMP_NAME1 = "" Then

I have fat fingers today too

mmcdonal · September 8th, 2006, 10:58 AM

Try this:
If IsNull(Me.CMP_Name1) = False Or Me.CMP_Name1 = "" Then

And what event did you put this on?

mmcdonal

mmcdonal · September 8th, 2006, 11:05 AM

Try putting this code on the report header's On Format event, since the text boxes are on the header, right?

mmcdonal

fubak · September 8th, 2006, 11:16 AM

Isn't there SOME way to control which record a textbox reads from? I feel like I'm spinning my wheels here :(

mmcdonal · September 8th, 2006, 11:38 AM

Why would you want to do that? If there is more than one value for the field, it should not be in the page header. You can put it in the detail or the detail sort field header. But not the report or page header.

How large is the database? Is it confidential? You can send a copy and we can work on it.

I am not sure if you can filter a recordsource for just one text box. Like:

Recordsource: [cmp_name1] WHERE [pk] = ?

mmcdonal

fubak · September 8th, 2006, 11:43 AM

Quote:

quote:Originally posted by mmcdonal
Why would you want to do that? If there is more than one value for the field, it should not be in the page header. You can put it in the detail or the detail sort field header. But not the report or page header.

How large is the database? Is it confidential? You can send a copy and we can work on it.

I am not sure if you can filter a recordsource for just one text box. Like:

Recordsource: [cmp_name1] WHERE [pk] = ?

mmcdonal

Wait, does the Header read data differently than the Detail?? Can you elaborate on that?

I can't post the DB b/c it's confidential. I'll try to give as much info as possible though.

It's an 'Invoice Report'. This particular report has 2 records that it's using to calculate what is displayed. The field CMP_NAME is blank for one of these records and the other record has what I want to be shown. I'm just tryin to get this damn thing to display what's in the record where that field is not Null :(