R
rahdirs
Is it possible to change the value of the Record Number Box (Withing th
Navigation Button). If so how?
Thanks
Sridha
Navigation Button). If so how?
Thanks
Sridha
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Do yo mean you would like to type in a number and have it go to that record?
Probably, but data is not stored in a table in a particular order. Deleting
records will cause items to shift up. Record number 50 today may be record
number 48 tomorrow.
Instead, use a unique field from your record (customer number, or customer
name, or employee number, etc.) and build a 'go to' text box that allows the
user to make an entry and then in the after update of that field, it goes to
the desired record.
Probably, but data is not stored in a table in a particular order. Deleting
records will cause items to shift up. Record number 50 today may be record
number 48 tomorrow.
Instead, use a unique field from your record (customer number, or customer
name, or employee number, etc.) and build a 'go to' text box that allows the
user to make an entry and then in the after update of that field, it goes to
the desired record.
R
rahdirs
Thanks for the reply, Rick. Here's what I am trying to achieve....
Form 1 & Form 2 have BOUNDED fields. When Form 2 is invoked from For
1, the Navigation Button value from Form 1 should be passed to Form 2
In other words, Form 2 should start displaying the same record on For
1 when invoked (Form 2 should not start from the first record). Use
input is to just click on the 'next', 'previous' buttons of th
Navigation Buttons at the bottom of the form
Form 1 & Form 2 have BOUNDED fields. When Form 2 is invoked from For
1, the Navigation Button value from Form 1 should be passed to Form 2
In other words, Form 2 should start displaying the same record on For
1 when invoked (Form 2 should not start from the first record). Use
input is to just click on the 'next', 'previous' buttons of th
Navigation Buttons at the bottom of the form
R
Rick B
Then you would pass the data to the second form. Open it and hae t go to
that record. You don't use the 'record number' though, you use some key
like I mentioned.
Record numbers are simply internal markers that accessuses to keep the data
straight. You should use some key field in your data.
I think the button wizard will even walk you right through opening the
second form. When ut asks you, click the radio button that says "Open the
form and find specific data to display. This will then let you point the
two related fields.
that record. You don't use the 'record number' though, you use some key
like I mentioned.
Record numbers are simply internal markers that accessuses to keep the data
straight. You should use some key field in your data.
I think the button wizard will even walk you right through opening the
second form. When ut asks you, click the radio button that says "Open the
form and find specific data to display. This will then let you point the
two related fields.
J
John Vinson
Is it possible to change the value of the Record Number Box (Withing the
Navigation Button). If so how?
Thanks
Sridhar
If you overtype it, Access will jump to that record in the form's
recordsource. You can't *edit* the value, because it's just reporting
that you're currently looking at the 312th record in the Form's
recordsource. You can't get away with telling Access "no, this is
really the 20th record" - it ISN'T, it's the 312th!
John W. Vinson[MVP]