Can't get past 2 Records, how to get 3,4,5...

M

martha.dempsey

ON Form_LOAD I have the following:

NewRecordMark Me
End Sub
Sub NewRecordMark(frm As Form)
Dim intnewrec As Integer

intnewrec = frm.NewRecord
If intnewrec = True Then
MsgBox "You're in a new record." _
& "Do you want to add new data?" _
& "If not, move to an existing record."
End If

I get to the next record but all I get is record 2 and the
new record * goes off. How can I get to add 3,4,5...?

thanks!
martha
 
P

PC Datasheet

You don't need any of this! When the form opens, just click on the button with
the asterisk at the far right of the navigation buttons. After entering your
data in a new record, click on the same button to save the record and go to
another new record.
 
M

martha.dempsey

You are right! It works! I was having problems with
indexes so any changes I made didn't save record #2 and
the asterisk would not available to move forward.
Corrected the index problems and I am off to the next item
(setting an account number to automatic populate with the
next number, i.e. Record #1 44-231, Record #2 44-232, so
on.

thanks!
martha
 

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

Top