Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a command button that would open a new record and keep
the meeting number from the current record and then give the next sequential
number to the meeting item.

Any help would be greatly appreciated.

Jana
 
In the onclick event of the button write the code

Dim meetingnumber as Double, meetingitem as Number

meetingnumber = Me.[meeting number Field Name]
meetingitem = Me.[meeting item Field Name]

DoCmd.GoToRecord , , acNewRec

Me.[meeting number Field Name] = meetingnumber
Me.[meeting item Field Name] = meetingitem + 1
 
Thank you very much. That worked great.

Ofer said:
In the onclick event of the button write the code

Dim meetingnumber as Double, meetingitem as Number

meetingnumber = Me.[meeting number Field Name]
meetingitem = Me.[meeting item Field Name]

DoCmd.GoToRecord , , acNewRec

Me.[meeting number Field Name] = meetingnumber
Me.[meeting item Field Name] = meetingitem + 1


--
In God We Trust - Everything Else We Test


[email protected] said:
I would like to create a command button that would open a new record and keep
the meeting number from the current record and then give the next sequential
number to the meeting item.

Any help would be greatly appreciated.

Jana
Click to expand...
Click to expand...
 

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

Access Automatically Send a notification email once a record is added 0
IPad remote 10
Access Command button to look up and copy data from a query to a table 0
Pre-Set Numbering 1
Command BUtton Caption on continuous forms 2
Command Button Caption on Continuous Form 5
Using one command button to open one of two reports 3
AUTONUMBER Field Increments after "UNDO / CLEAR FORM" 1

Back
Top