2 ways to search thru records with combo box

hello,
am attaching a sample database with 2 forms.
open database and open form1-
I have  code in combo box.
   [Dim rs As Recordset
  Set rs = Me.Recordset.Clone
  rs.FindFirst "[ClientID] = " & Me.cboSelectClient.Value
  If Not rs.EOF Then Me.Bookmark = rs.Bookmark]

I realized I can also create with the wizard (form2)-the same type of search.

question: they both use the same query in the row source of the combobox.But I don't understand how form2 can work without the code that form1 has.
Can you explain the differences of the two forms?
thank you
TestA.accdb
davetoughAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
As an aside, embedded macros are new to Access 2010.

My personal preference is still VBA like you have behind Form1.  I find it easier to develop, better organised, and find the error messages more meaningful.
0
 
mbizupCommented:
Your second form is using an Embedded Macro that does effectively the same thing as the VBA in the After Update event of Form 1.

Here's a screenshot:
Embedded Macro
0
 
davetoughAuthor Commented:
Thank you- ( apoligize for delay - purchasing new computer)
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.