davetough
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you- ( apoligize for delay - purchasing new computer)
Here's a screenshot: