By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,527 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,527 IT Pros & Developers. It's quick & easy.

Record Number

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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.)

Nov 13 '05 #5

P: n/a
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
Nov 13 '05 #6

P: n/a
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

Nov 13 '05 #7

P: n/a
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
Nov 13 '05 #8

P: n/a
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

Nov 13 '05 #9

P: n/a
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

Nov 13 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.