Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only able to navigate through newly entered data

Status
Not open for further replies.

mbaddar

Programmer
May 10, 2001
120
US
Hi,

I have an MS Access 2000 form I'm creating. There
are record navigation buttons on the form (next, previous,
first and last record). For some reason, I can only navigate to the records that have just been entered into the system. For example, if a user goes into this form and enters three records, he can browse with the next and previous buttons through these 3 records only. There are probably, however, already several hundred records in the table that the form is bound to. So, why in this case, can't a user navigate through the records that are already in the table?

Any ideas?

Thanks,
MBaddar
 
sounds like your form is in the data entry mode either change it in properties. Or right click on the form and click remove filter

 
mbaddar,

Check to see if you have DATA ENTRY = Yes on your form properties.

K.Hood
 
Oops, must have been responding at the same time as gol4. At least we said the same thing!
 
Bingo, thank you both! That did it.

MBaddar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top