Control button to move to next, previous, first etc not working

[Guest]

I have created a simple database for staff to enter and modify purchase
queries. On the switchboard screen I have created control boxes to move to
next, previous, first and last records. However when they are used they do
not work in the way that is expected. Also the default box to move through
records also does not work in the normal order. Help please!

 

[Douglas J Steele]

Without knowing what code you're using, it's pretty much impossible for
anyone to help you.

For an example of custom navigation buttons that do work, check what Stephen
Lebans has at http://www.lebans.com/recnavbuttons.htm

I have no idea what you're referring to by "the default box to move through
records"

 

[Rick B]

You don't tell us what they do that is not "in the way that is expected".
What *do* they do?

You built these on a switchboard? Typically record navigation would be
handled in your data entry/revision form. Switchboards don't typically
display records.

What are the buttons? How did you build them? Did you use the wizard?
What is the code behind them?

The default buttons don't work? What do they do? Do you have records in
the data source so there is a first, last, etc. record? How many records
are there according to the record box at the bottom of your screen?

We need many more details to help you with this.

 

[Guest]

Sorry did not explain myself correctly. In design view on a form, from the
toolbox used command buttons for next record, previous record, last record,
first record. On using these on a stand alone version, these buttons move
you as requested, back a record, forward a record, to the first record and to
the last record. As do the Record navigation controls arrows (default in
Access at the bottom left of the screen).

When the database is used on the network by multiple users, for example on
using the First record option from either the command button or Record
navigation area, it does not take users back to the very first record, but
just one record in the database.

Hope I have explained myself better and apologies.