Can't NAVIGATE Records

[kev100 via AccessMonster.com]

I've created a fairly basic form for entering data into a table.

It is pretty staight-forward.

Most of the text boxes are simply drag-n-drops from the field list....But....
a few perform calculations and display the results (a few averages, etc).....
and there are also...a few combo boxes used to make data entry easier (e.g.
one is for MONTH and has all the months listed in the pull-down).

---------------------------------

The issue is Navigating back thorough PREVIOUSLY ENTERED records.

I have Record Navigation set to YES in the form's properties....and the First
/ Next / Previous / Last buttons do show at the bottom.

HOWEVER......I can only navigate through records that have been entered in
the Current Session.

For example. I could make 10 new entries....and be able to scroll back and
forth through all 10. But....if I exit the app (Access) and then open it
back up.....I can't navigate through any....it's as if nothing is in the
table (but all previous entries are there).

When testing....I did notice that if I just dump all fields on a form (and do
NOT make any calc or combo text boxes)....then open it up.....Navigating to
previously entered records is no problem.

Does the use of calculated or combo text boxes somehow disable Record
Navigation...or could it be some other setting, etc.?

Thanks

 

[Marshall Barton]

I've created a fairly basic form for entering data into a table.

It is pretty staight-forward.

Most of the text boxes are simply drag-n-drops from the field list....But....
a few perform calculations and display the results (a few averages, etc).....
and there are also...a few combo boxes used to make data entry easier (e.g.
one is for MONTH and has all the months listed in the pull-down).

---------------------------------

The issue is Navigating back thorough PREVIOUSLY ENTERED records.

I have Record Navigation set to YES in the form's properties....and the First
/ Next / Previous / Last buttons do show at the bottom.

HOWEVER......I can only navigate through records that have been entered in
the Current Session.

For example. I could make 10 new entries....and be able to scroll back and
forth through all 10. But....if I exit the app (Access) and then open it
back up.....I can't navigate through any....it's as if nothing is in the
table (but all previous entries are there).

When testing....I did notice that if I just dump all fields on a form (and do
NOT make any calc or combo text boxes)....then open it up.....Navigating to
previously entered records is no problem.

Does the use of calculated or combo text boxes somehow disable Record
Navigation...or could it be some other setting, etc.?

No, those things have nothing to do with navigation.

The first thing I would suspect is that you are openung the
form with the DataMode argument set to acFormAdd. Or maybe
you have a criteria in the form's record source query that
does something funny.

 

[kev100 via AccessMonster.com]

The first thing I would suspect is that you are openung the
form with the DataMode argument set to acFormAdd. Or maybe
you have a criteria in the form's record source query that
does something funny.

Yes....FormAdd.....

It does use that setting. I was wanting it to be as "handy" as possible for
fast data entry. This way....it's blank and ready to start punching in.

It would great to have both features (form open's blank ready for entry AND
being able to browse)....if possible. But.....if it's an either/or deal......
I can just remove the FormAdd function.

Am I just going to have to choose one?

Thanks very much.

 

[John Vinson]

HOWEVER......I can only navigate through records that have been entered in
the Current Session.

Sounds like you have the form's Data Entry property set to Yes. That's
the function of this setting; set it back to the default No and you'll
be able to see all records.

John W. Vinson[MVP]

 

[John Vinson]

It would great to have both features (form open's blank ready for entry AND
being able to browse)....if possible. But.....if it's an either/or deal......
I can just remove the FormAdd function.

Am I just going to have to choose one?

You can use a bit of VBA code in the Form's Open event:

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNew
End Sub

to get the best of both.

John W. Vinson[MVP]

 

[Rick Brandt]

Data Entry mode is nothing more than a special filter. If you open a form in
Add mode all you have to do is apply a different filter or "remove all filters"
to see other records.

 

[kev100 via AccessMonster.com]

Sounds like you have the form's Data Entry property set to Yes. That's
the function of this setting; set it back to the default No and you'll
be able to see all records.

John W. Vinson[MVP]

Thanks folks......setting the DataEntry back to NO did the trick.

It opens the the first record in the table....but all the user has to do is
click the * button to jump to a blank record.

Thanks!