M
myxmaster
I am attempting to select a record(s) on a form based on a combo box.
I used the wizard and placed a combobox in the header and asked it to
select a record on the form however this only offers the options of
fields on the form.
I then created a combobox based on a table with the fields:
Credit
Check
Cash
Safe Keeping
I would like the user to select on of the above from the combobox and
filter all records within that category. The field I would like to
filter is called category. I used the following code but have no luck
Private Sub Combo24_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Category] = " & Str(Nz(Me![Combo24], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
TIA
I used the wizard and placed a combobox in the header and asked it to
select a record on the form however this only offers the options of
fields on the form.
I then created a combobox based on a table with the fields:
Credit
Check
Cash
Safe Keeping
I would like the user to select on of the above from the combobox and
filter all records within that category. The field I would like to
filter is called category. I used the following code but have no luck
Private Sub Combo24_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Category] = " & Str(Nz(Me![Combo24], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
TIA