Next Record Button

[data808]

I have a button to navigate to the next record. I also have a button to add a new record. I want the next record button to be able to navigate to the next record but I don't want it to be able to create a new record if I click the button while being on the last record. I want it to stop at the last record, making my add a new record button the only way to create a new record.

Does anyone know how to do that?

[June7]

Options:

1. Set the form Allow Additions property to no and code behind the Add Record button manages allowing new record

2. Code behind Next button checks if the current record is the last record of the form recordset
If Me.CurrentRecord <> Me.RecordCount Then

[data808]

I'm not good with the codes. Is there a specific code you can suggest for the Add Record button? And do I put the code on an event like "On Click"?

The code for the Next button, is that all I need? Where do I put it? In an event?

[June7]

Code goes in the button Click event.

You don't already have code behind these buttons?

[data808]

I have code behind the buttons but it is the default code that is used through the button wizard so I did not manually add any code myself. So if I understand correctly, the code you provided is the only thing I need to add to the Next Record button? Does it have to be the first action? Or can it be the last action?

Since we are on the subject of buttons, I was wondering if you would have the answer to another situation I am having. I have created a button for Find Record. By default, it works but the thing I don't like about it is that you need to click on the field that you want to search. The "Look in" part of the search only allows for me to choose the field I am currently in. Is there a way so that the search box lists all fields in the "Look in" section? I hate having to make sure I click on the field box that I want to do a search in every time.

[data808]

Ok I tried this just now and I don't think I did the code correctly because I do not know how to add that into the button. The Allow Additions property set to No stopped the next record button from creating a new record, however, it also stopped the Add New Record button as well.

When adding the code you mentioned: If Me.CurrentRecord <> Me.RecordCount Then
Where do I put it? I tried adding it in the On Click event but there is already an action listed that was there by default when creating the button using the wizard. So I tried typing it into the action field but I'm not sure that's how you are supposed to add it.

[June7]

What do you mean by 'action field'? The Click event property box on the Property Sheet? Do not type code there. VBA code goes in the VBA editor. Can type code into any procedure, even if generated by wizards (I don't use the wizards).

[data808]

The code you provided seems to be incomplete. Is there any chance you have the whole thing to make this work?

[June7]

That was only the first line of the procedure. The rest could be like:

If Me.CurrentRecord <> Me.RecordCount Then

'your code to move to next record

Else

'do something, maybe just a message box
MsgBox "This is the last record."

End If