newbie help

[myxmaster]

Hello,
I am using access 2003 . I have a table with, check, cash, credit. I
have set up 3 forms, 1 for each category to display the information.
However I thought there must be a way with a combobox, listbox or
option group to display the chosen category. If the user selects cash
I would like to display the information maybe in a subform?.
Any help is most appreciated.
thx

 

[Guest]

Yes, you can use a combobox and display the results based on entry selected
in combo box.

I believe the vb code goes like this (this is to find customer info based on
customer name slected in combo box):

Private Sub cboCust_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[CustomerID] = " & Str(Me![cboCust])
Me.Bookmark = rs.Bookmark
End Sub

Hope this helps.