Forms' Native Functionality vs VBA

I am new to Access, but well versed in VBA for Office.   I need to achieve a certain functionality on a form and my instincts are to use VBA - but the "form" paradigm in Access is clearly different from what it is for the other Office applications and I may be making extra work for myself.

In short, I want the user to use either of  two controls to select a "deal", namely Deal ID or Deal Name.  I have programmed two combo boxes to "sync" values with event handlers as follows:


'ACCESS VBA****************************************************************

Option Compare Database
Option Explicit

Private EventsEnabled As Boolean

Private Sub Form_Load()
    EventsEnabled = True
End Sub

Private Sub cbxDealID_AfterUpdate()
    If Not EventsEnabled Then Exit Sub
    EventsEnabled = False
        Me.cbxDealName.Value = Me.cbxDealID.Column(1, Me.cbxDealID.ListIndex)
    EventsEnabled = True
End Sub

Private Sub cbxDealName_AfterUpdate()
    If Not EventsEnabled Then Exit Sub
    EventsEnabled = False
        Me.cbxDealID.Value = Me.cbxDealName.Column(1, Me.cbxDealName.ListIndex)
    EventsEnabled = True
End Sub

'****************************************************************


Is this really the best way to do this?  Knowing what I know of Access, I suspect there's a smarter, less technical way to achieve the same sort of result.  I've attached a file for reference.  Any suggestions / opinions?

Mike


Start Free Trial