Record Number

[DS]

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

[PC Datasheet]

Me.CurrentRecord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

[DS]

PC Datasheet wrote:

Me.CurrentRecord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

[DS]

DS wrote:

PC Datasheet wrote:

Me.CurrentRecord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that
number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

PS How do you grab this number and place it into a field on the form?
Thanks
DS

[notright]

I don't know if this is the best way to do it, but in the subform,
under the default value property, I set it to look at the field on the
master form that I want that to be. That is for a data entry only form
though. Otherwise, the field on the sub form would be whatever you
replace that value with. (I hope that makes sense.)

[DS]

notright wrote:

I don't know if this is the best way to do it, but in the subform,
under the default value property, I set it to look at the field on the
master form that I want that to be. That is for a data entry only form
though. Otherwise, the field on the sub form would be whatever you
replace that value with. (I hope that makes sense.)

I was thinking also (Again)!. I just need to get that number or create
a field that defaults at 1 then increments by 1 as it goes to the next
record. Now the question is how do I do that? Or is it better to grab
the CurrentRecord Number?
Thanks
DS

[PC Datasheet]

I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the
Linkchild set as the corresponding foreign key in the subform, everytime you
enter a new record in the subform, Access will automatically enter the value
for the foreign key which will be the same value as the primary key in the
main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:bo*************@fe09.lga...

PC Datasheet wrote:

Me.CurrentRecord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

[DS]

PC Datasheet wrote:

I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the
Linkchild set as the corresponding foreign key in the subform, everytime you
enter a new record in the subform, Access will automatically enter the value
for the foreign key which will be the same value as the primary key in the
main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:bo*************@fe09.lga...

PC Datasheet wrote:

Me.CurrentRecord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that
number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

After much thought, yes the autonumber does work, but I'm afraid that
it's going to get pretty high after a few weeks use. So I thought that
maybe I would like the number to start at 1 and go up by 1 on the next
record. The number n the main form is an auto number. This number
starting at 1 is on the subform. So I was wondering how to set up a
number field that would increment by 1 on the next record.
I hope this is clearer.Thanks
DS

[PC Datasheet]

Don't worry about the size of an autonumber field; it can go to over two
trillion. You and I will never see that many records!! Why don't you post
the tables and fields your main form and subform are based ob and we will
take a look to see if they are correct.

Steve
PC Datasheet
"DS" <bo******@optonline.net> wrote in message
news:o1**************@fe09.lga...

PC Datasheet wrote:

I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the Linkchild set as the corresponding foreign key in the subform, everytime you enter a new record in the subform, Access will automatically enter the value for the foreign key which will be the same value as the primary key in the main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:bo*************@fe09.lga...

PC Datasheet wrote:

Me.CurrentRecord will give you the same number you see in the navigationbuttons at the bottom left of the screen. In a continous form, that

number

will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DS" <bo******@optonline.net> wrote in message
news:fe*************@fe09.lga...
>Whenever you use a continous form each row represents a record. Does
>this record have a number? If so how do you access it. Right now I
>have a field using auto number. But if access generates its own number>for that row I'd like to use that.
>Thanks
>DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

After much thought, yes the autonumber does work, but I'm afraid that
it's going to get pretty high after a few weeks use. So I thought that
maybe I would like the number to start at 1 and go up by 1 on the next
record. The number n the main form is an auto number. This number
starting at 1 is on the subform. So I was wondering how to set up a
number field that would increment by 1 on the next record.
I hope this is clearer.Thanks
DS

[Ronald W. Roberts]

DS wrote:

Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own
number for that row I'd like to use that.
Thanks
DS

The answer is no.

Ron

--
Ronald W. Roberts
Roberts Communication
rw*@robcom.com