Forms, blank entry

G

Guest

I have a minor problem I can not seem to solve.

here is the code i have for find next
Private Sub cmdNextChild1_Click()
On Error GoTo Err_cmdNextChild1_Click


DoCmd.GoToRecord , , acNext

Exit_cmdNextChild1_Click:

Exit Sub

Err_cmdNextChild1_Click:
DoCmd.GoToRecord , , acFirst

End Sub

this finds the next record, then loops back to the first record. However,
before it will back to the first record, it shows a blank record.

I would like to know if there is a way for the blank record not to show and
have it looped back to the first record?

Thanks in advance..

Lisa
 
G

Guest

You have a blank record because the AllowAddition property of the form is set
to yes, if you don't want this blank line set it to No
 

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

apostrophe in record 6
Printing records on Access 2000 0
acNext 3
Access goto next record for two tables 9
Repeat Expression 2
Last Record Error 3
Recordset.EOF not working 5
Loop/Repeat Code 5

Top