Problem Syncing 2 Combo Box, I can't determine why my after event code is not working

[AdmiralN]

Hi,

I'm very new to Access and having great difficultly trying to sync 2 combo boxes. I have been using The MS Access help for this issue. I have one Combo box titled sboPackageNumber and and another titled sboPackageDescription. My Table the data is taken from is called Sheet1. The columns on the table are Package Number and Package Description.

My code is as follows:

Sub Me.sboPackageDescription.RowSource = "SELECT Package_Description FROM" & _
   " Sheet1 WHERE Package_Number = " & Me.sboPackageNumber & _
   " ORDER BY Package_Description"
Me.sboPackageDescription = Me.sboPackageDescription.ItemData(0)
 
End Sub

I'm currently getting Compile error : Expected:identifier

Thanks in advance.

[zmbd]

Sub Me.sboPackageDescription.RowSource = "SELE (...)
is malformed!!!

At best your code should appear to be something like:

Sub yourProcedureNameHere() 
'
'You should build your rowsource string first
  Dim myRowSQL as String
  myRowSQL = _
    "SELECT Package_Description FROM" & _
       " Sheet1 WHERE Package_Number = " & _
       Me.sboPackageNumber & _
       " ORDER BY Package_Description"
'that way you can insert the following, <Ctrl><g> and see the result to check for proper form.
'  Debug.Print myRowSQL
'
  Me.sboPackageDescription.RowSource = myRowSQL
'
  Me.sboPackageDescription.ItemData(0)
'
End Sub 

Take a read thru this insights article... I think this may be along the train of thought you're following:
Bytes > Sitemap > Microsoft Access / VBA Insights>Cascading Combo/List Boxes

I'll also send you a boilerplate with, imho, some better resources for things Access/VBA :) Bytes.com>InBox

[AdmiralN]

Thanks very much for your help and for taking the time to reply!