Cycling through records

  • Thread starter Thread starter Sabram
  • Start date Start date
S

Sabram

Hi

I have a form with a command button to cycle through all the records in a
table using "DoCmd.GoToRecord , , acNext". How can I stop the form from
going beyond the last record and opening a new record?

Thanks

SteveB
 
Dear Sabram:

A form has an "Allow Additions" property. Set this property to "No".

HTH
Fred Boer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping until end. 2
Next Record button creates a new record 2
Access goto next record for two tables 9
Automatically scroll through records 11
Printing records on Access 2000 0
Loop/Repeat Code 5
Last Record Error 3
Recordset.EOF not working 5

Back
Top