Tab Control and Record Operations

Using MS Access 2000

i created a form and then place a tab in it. the tab doesn't have buttons for record operations (add, delete, etc.) and record navigation (find next, find precious, etc).

i want my tab to have this capability bec i'm going to place fields (text boxes, combo boxes) in them so that the user can modify the contents of my table.

i tried inlcuding command buttons using the wizard. i'm able to create, say, a save button in the tab -- just that it doesn't actually save anything when clicked.

any advice?
LVL 1
kiphughesAsked:
Who is Participating?
 
PaurthsConnect With a Mentor Commented:
hi kiphughes,

i know the wizard does that for u. But sometimes with tab-elements the code is no longer connected to the button.
U have to make sure that the click-event of the button is shown in the properties window of the button.

try to add a line to the code, to see if it runs the code:

Private Sub Save_Click()

   DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
msgbox "Ok, passed"

end sub

cheers
Ricky


0
 
PaurthsCommented:
hi Kiphughes,

if u have created the button using the wizard.
select the button, and open the properties window.
Scroll down until u see 'onClick'.  
Put the mouse pointer in it and click. On the right u will see a button with arrow, choose it and it should show 'Eventprocedure'. Select this. Save the form and try your actions again.

cheers
Ricky

ps: might be that the actual naming i used is a little off, since i only have a dutch version.
0
 
kiphughesAuthor Commented:
the wizard automatically does that for you. try stepping throught the wizard and u'll see what i mean. the code it generates is this:

Private Sub Save_Click()
On Error GoTo Err_Save_Click


    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Save_Click:
    Exit Sub

Err_Save_Click:
    MsgBox Err.Description
    Resume Exit_Save_Click
   
End Sub

i don't know what it means. but whatever it is, it doesn't save me stuff.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.