Find, Previous, Next Command buttons using the wizard.

[GFullington]

I created two forms that use the find, previous, and next command buttons via the wizard. In one form, the buttons work as expected, finding a record and allowing navigation through all the records using the previous and next. In the other form, the find, previous and next only work on the current displayed record. I referenced the MS knowledge base (#150665) but the mentioned solution does not work.
Is there something in the way a form is set up that allows the find, previous and next buttons to function differently?
Does someone have code for these buttons to pass along?
Is this related to the "bookmark bug"?

 

[Darrylles]

Hi GF,

What is the difference between the forms?

You only know that. There MUST be a difference, otherwise you wouldn't need 2 forms.

Tell us what each form does.

There is absolutely no bug involved, just a property or difference in how you've set the form to work.
(To prove this, copy your correctly working form, paste it with a different name - then run it).

Regards,

Darrylle



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[WayneRyan]

G,

I don't know what you mean by "only working on the current
record". Could your problem be related to the "sort order"
of the form itself?

Wayne

 

[Darrylles]

Hi again,

Does this form only ever contain one record?

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[GFullington]

I figured out the problem by playing with the form properties, but I will provide details also;
Running Access 97 sr-2.
The two forms are for two different tables in the same DB.
Each table contains multiple records.
No sort order is specified on either form.

On the form where the buttons are functioning correctly, the form property "Data Entry" is set to No. The other form
it was set to "Yes". When I changed the "Data Entry" property to "No", the buttons functioned correctly ie.

What I meant by "only working on the current record", is the find only searches the displayed record for the value as apposed to searching all the records in the table. The previous button gives the message "You can't go to the specified record set" and the next button takes you to the last record (new record).