I am trying to create a form to make it easier to modify a record
without having to page through all the records. I have started the
form with 3 cascading combo boxes. ie #1 asks for division , #2 is
populated with just the customers in the division specified by #1 and
then #3 is just the Parts for the customer in #2. This part works
great. I now need to set the code in the after update of the #3 combo
box to pull up the record that goes with this data by using the choices
of the 3 combo boxes.
Here is the code that I have but it is bombing out on the
"myset.FindFirst" statement, with a error Compile Error - Methode or
Data Member not found.
Any help is greatly appreciated.
Private Sub Part_Number_Sel_cbo_AfterUpdate()
Dim myset As Recordset
Dim strSearchDivison As String
Dim strSearchCustomer As String
Dim strSearchPart As String
Set myset = Me.RecordsetClone
strSearchDivsion = Me!Divison_Sel_cbo.Value
strSearchCustomer = Me!Customer_Sel_cbo.Value
strSearchPart = Me!Part_Number_Sel_cbo.Value
myset.FindFirst "[Divison] = '" & strSearchDivison & "' and
[Customer] = '" & strSearchCustomer & "' and [Part Number] = '" &
strSearchPart & "'"
Me.Bookmark = myset.Bookmark
Thank you,
Darren