NavigationsButtons question

  • Thread starter Thread starter BobC
  • Start date Start date
B

BobC

I noticed that when I create a form using the wizard that it puts in
Navigation Buttons.
The Navigation buttons however seem to work on the record number and not
on the key field.
Can I change this so the the key field in shown?
 
BobC said:
I noticed that when I create a form using the wizard that it puts in
Navigation Buttons.
The Navigation buttons however seem to work on the record number and not
on the key field.
Can I change this so the the key field in shown?
Click to expand...

If you're referring to the numbers then no. They are merely the ordinal
position of the current record within the current RecordSet.
 
OK ... not what I 'wanted' to hear.
Would you know if I can recreate something that does functionally the
same thing with a combo box, including creating a new record?
 
I guess I am wanting to do two things:
1) When I scroll through the records, I want the records to be in
alphabetical order based on the key'd field.
2) I want to be able to add addional records by selecting the *
Am I asking too much?
Thanks for helping!
 
If your form's "Record Source" is based on a query, set the sort for the key field to Ascending and move it to the first position in the query grid. If your form's "Record Source" is based on a table, click on the Build button (...) to the right of that property's field and, when asked if you want to build a query based on the table, answer "Yes". Then, in the query builder, drag all of the fields in the table list into the grid columns below, with the key field in the first position, and set the key field's Sort to Ascending. Now your form's records will be sorted on the key field's value and clicking on the ">*" on the navigation bar will move you to a new record.

Is this what you were asking for?

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)within the newsgroups so that all might benefit.<<
I guess I am wanting to do two things:
1) When I scroll through the records, I want the records to be in alphabetical order based on the key'd field.
2) I want to be able to add addional records by selecting the *
Am I asking too much?
Thanks for helping!

Dan Artuso wrote:

Hi,
No. Just display the key field in a textbox on your form.

--
HTH
Dan Artuso, Access MVP


I noticed that when I create a form using the wizard that it puts in
Navigation Buttons.
The Navigation buttons however seem to work on the record number and not
on the key field.
Can I change this so the the key field in shown?
 
YES!!!!
Thank YOU!
The form was based on a table ... I followed your instructions and it
works as I wanted.
I noticed that the query I created did not show up on my list of queries
.... I guess it is just a SQL statement.
Would there be any advantage to creating a query instead?
 
I guess I am wanting to do two things:
1) When I scroll through the records, I want the records to be in
alphabetical order based on the key'd field.
Click to expand...

Base the Form on a Query sorting by that field. The records will be in
an arbitrary order if you base the form on a table.
2) I want to be able to add addional records by selecting the *
Click to expand...

ummm... you can, already. Are you having a problem with the *> key
going to the New Record?
 
It has created a query, just hasn't saved it in your database window list of
"Queries". You can save it by choosing Save on the File menu while you have
the query view opened.

I've read that its a "best practice" to always save queries as named queries
rather than keeping them embedded in the form. The only reason I can think
of for this is the ability to use them in other forms or reports as well
without having to re-create them, and the ease of modifying them without
opening form in design view. So I often save them, but not always. Would
love to hear more pros and cons on this.

John Loewen


YES!!!!
Thank YOU!
The form was based on a table ... I followed your instructions and it works
as I wanted.
I noticed that the query I created did not show up on my list of queries ...
I guess it is just a SQL statement.
Would there be any advantage to creating a query instead?


Bruce M. Thompson wrote:

If your form's "Record Source" is based on a query, set the sort for the key
field to Ascending and move it to the first position in the query grid. If
your form's "Record Source" is based on a table, click on the Build button
(...) to the right of that property's field and, when asked if you want to
build a query based on the table, answer "Yes". Then, in the query builder,
drag all of the fields in the table list into the grid columns below, with
the key field in the first position, and set the key field's Sort to
Ascending. Now your form's records will be sorted on the key field's value
and clicking on the ">*" on the navigation bar will move you to a new
record.

Is this what you were asking for?

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)within the newsgroups so that all might benefit.<<
I guess I am wanting to do two things:
1) When I scroll through the records, I want the records to be in
alphabetical order based on the key'd field.
2) I want to be able to add addional records by selecting the *
Am I asking too much?
Thanks for helping!

Dan Artuso wrote:

Hi,
No. Just display the key field in a textbox on your form.

--
HTH
Dan Artuso, Access MVP



I noticed that when I create a form using the wizard that it puts in
Navigation Buttons.
The Navigation buttons however seem to work on the record number and not
on the key field.
Can I change this so the the key field in shown?
 
Back
Top