Start Report Numbering at 4

[fhwa]

Here's my dilemma, I'm trying to create a report with a subreport in
the query. And what I need it to do is instead of starting an item
numbering at 1 when the source =1, I need it to start numbering at 4.
I'm getting quite frustrated and am very new to VBA code and whatnot.
All the other cells except for total come off a query, but the
numbering is automatic with the report. I appreciate all and any
help!

My report looks like this:

1 Description Price Quantity Total
2 Description Price Quanitty Total
3 Description Price Quanitty Total
4 Description Price Quanitty Total

I need it to look:

4 Description Price Quanitty Total
5 Description Price Quanitty Total
6 Description Price Quanitty Total
7 Description Price Quanitty Total

 

[ruralguy via AccessMonster.com]

What is the ControlSource for the control that displays the line numbers?

 

[fhwa]

What is the ControlSource for the control that displays the line numbers?










--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1- Hide quoted text -

- Show quoted text -

Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks

 

[ruralguy via AccessMonster.com]

Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
several ways to solve this problem. Post back if you need further assistance,

What is the ControlSource for the control that displays the line numbers?

[quoted text clipped - 27 lines]

- Show quoted text -

Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks

 

[fhwa]

Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
several ways to solve this problem. Post back if you need further assistance,

[quoted text clipped - 27 lines]

- Show quoted text -

Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1

ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?

 

[ruralguy via AccessMonster.com]

OK, just set the ControlSource to =Text16 + 4 and see what happens.

Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are

[quoted text clipped - 18 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1

ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?

 

[fhwa]

OK, just set the ControlSource to =Text16 + 4 and see what happens.

Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are

[quoted text clipped - 18 lines]
ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1

I swore I tried that same thing before and it didn't work. Oh well
it's working now. thanks alot for the help...

 

[ruralguy via AccessMonster.com]

You're welcome. Glad I could help.

OK, just set the ControlSource to =Text16 + 4 and see what happens.

[quoted text clipped - 16 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1

I swore I tried that same thing before and it didn't work. Oh well
it's working now. thanks alot for the help...