I need to make a form in access with the usual text controls and 3 buttons : Add Modify and Delete... I have done this kind of stuff in VB but never in VBA...I thought it would be very similar...but when I looked at some sample code that was given to me.. I did not make any sense to me...neither do I have any access to any VBA books....

a) Can anyone point me to a VBA tutorial\code sample for Data Entry Forms in particular...ones with Add Modify Delete Find etc. in them ???

b) I have a code sample right here that is not making any sense to me...makes sense to you ?

VB Code:
  1. Private Sub cmdFind_Click()

  2. On Error GoTo Err_cmdFind_Click

  3.  
  4.     Me!frmEquipSummary.Requery

  5.     DoCmd.RepaintObject

  6.     Me!txtEquipID = [Forms]![frmEquipMain]![frmEquipSummary]![txtEquipID]

  7.  

  8. Err_cmdFind_Click:

  9.     Exit Sub

  10.     

  11. End Sub

a)...how does this syntax work...Me!frmEquipSummary.Requery ?
b) I couldnt find this object DoCmd defined anywhere...is this a part of some standard library thing or what
c) What is the whole deal with these square brackets in the 3rd statement