Next Record in a Subform

[drStealth]

Hello all,

I have a form / subform structure working well. The intent is to enter multiple inventory items for each location. Example, one person's cube may have a workstation, telephone, printer. The Main form identifies the cube's code, the subform is linked to the main form by this code and allows for the multiple items to be entered to the table.

Right now the user needs to advance to the next record in the subform by clicking the MS_Access -> arrow button at the bottom of the subform. Example, the user will enter Cube A1 at the main form. The subform will be blank to start, then display the A1 cube code to indicate the link to the main form. The user then will enter the workstation as an item. Then to enter a telephone, he/she will need to click the -> arrow to advance to the next record.

I'd like to create a button to accomplish the same thing, that is, have the user click the button to advance a record in the subform instead of the right arrow. How to do? Thanks to all. drStealth

 

[BobJacksonNCI]

Use the button wizard with the form in design view.

To advance to a new record:
Category = Record Operations
Actions = Add New Record

To advance to the next record (for existing records):
Category = Record Navigation
Actions = Goto Next Record

HTH,
Bob

 

[drStealth]

Bob, as usual I tried to make it harder than it should be.
Your suggestion worked like a charm, I appreciate the assist. Thanks. drStealth