469,317 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Report Blank When Cursor is on Blank Line?

My basic question is why does my print report button on my subform print a
blank report when my cursor is on a blank entry line? Here is a more
detailed explanation of my problem.
I have a form that contains shipment destination information and a subform
that contains boxes for that shipment. The main form is a table called
Ship_Info, and the subform is a table called Label_Info. They both contain
and are linked by a field called Load_ID. My report is called "Load Sheet".

I have a button on the subform that prints the records only on that subform
to the "Load Sheet" report. This works great. The subform is a continuous
sheet, so as I add fields, it adds another blank line below to enter another
record. I move from field to field in the form by hitting tab or enter.
When I hit tab or enter, it moves my cursor to the next blank line. If I
hit the "Print Load Sheet" button on the subform while my cursor is in the
blank line, the report is blank. If I move my cursor to the previous
record, the report has all the records on the subform like it should. The
records seem to be savedIs there something I can do so that it will print
the records when I am on the blank line? The records seem to

I am using:

Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"

on a few fields to populate the next field with the same value--if this
makes any difference.

I am using:

DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" &
Me![Load_ID] & "'"

to print my Load Sheet from the subform.

Any information would be appreciated.

Thanks,

Chad
Nov 13 '05 #1
5 2208
how about checking whether the line you are currently on is new but not
dirty and then moving to the previous record if it is. Then print.

Nov 13 '05 #2
Sounds good. How exactly do I do that? I need to be able to print while on
the balnk line.

Chad
<pi********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
how about checking whether the line you are currently on is new but not
dirty and then moving to the previous record if it is. Then print.

Nov 13 '05 #3
Sorry, I should elaborate, I understand the dirty command, but I how to
I move to the previous records? If you have already responded. Ignore
this message.

Thank You,

Chad

Nov 13 '05 #4

ChadDiesel wrote:
My basic question is why does my print report button on my subform print a blank report when my cursor is on a blank entry line? Here is a more detailed explanation of my problem.
I have a form that contains shipment destination information and a subform that contains boxes for that shipment. The main form is a table called Ship_Info, and the subform is a table called Label_Info. They both contain and are linked by a field called Load_ID. My report is called "Load Sheet".
I have a button on the subform that prints the records only on that subform to the "Load Sheet" report. This works great. The subform is a continuous sheet, so as I add fields, it adds another blank line below to enter another record. I move from field to field in the form by hitting tab or enter. When I hit tab or enter, it moves my cursor to the next blank line. If I hit the "Print Load Sheet" button on the subform while my cursor is in the blank line, the report is blank. If I move my cursor to the previous record, the report has all the records on the subform like it should. The records seem to be savedIs there something I can do so that it will print the records when I am on the blank line? The records seem to

I am using:

Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"

on a few fields to populate the next field with the same value--if this makes any difference.

I am using:

DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" &
Me![Load_ID] & "'"

to print my Load Sheet from the subform.

Any information would be appreciated.


When you're on a new record in your subform, [Load_ID] won't have a
value yet and will not have a value until the record is saved. If I
were you I would modify my OpenReport code to use the value of
[Load_ID] from the parent form, e.g.

DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= '" &
Me.Parent.Form![Load_ID] & "'"

HTH,
Bruce

Nov 13 '05 #5
Thanks for the information. That worked great.

Chad

<br***@aristotle.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

ChadDiesel wrote:
My basic question is why does my print report button on my subform

print a
blank report when my cursor is on a blank entry line? Here is a more

detailed explanation of my problem.
I have a form that contains shipment destination information and a

subform
that contains boxes for that shipment. The main form is a table

called
Ship_Info, and the subform is a table called Label_Info. They both

contain
and are linked by a field called Load_ID. My report is called "Load

Sheet".

I have a button on the subform that prints the records only on that

subform
to the "Load Sheet" report. This works great. The subform is a

continuous
sheet, so as I add fields, it adds another blank line below to enter

another
record. I move from field to field in the form by hitting tab or

enter.
When I hit tab or enter, it moves my cursor to the next blank line.

If I
hit the "Print Load Sheet" button on the subform while my cursor is

in the
blank line, the report is blank. If I move my cursor to the previous

record, the report has all the records on the subform like it should.

The
records seem to be savedIs there something I can do so that it will

print
the records when I am on the blank line? The records seem to

I am using:

Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"

on a few fields to populate the next field with the same value--if

this
makes any difference.

I am using:

DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" &
Me![Load_ID] & "'"

to print my Load Sheet from the subform.

Any information would be appreciated.


When you're on a new record in your subform, [Load_ID] won't have a
value yet and will not have a value until the record is saved. If I
were you I would modify my OpenReport code to use the value of
[Load_ID] from the parent form, e.g.

DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= '" &
Me.Parent.Form![Load_ID] & "'"

HTH,
Bruce

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.