C
Chey
I have a code under current
For 2 combo boxex
Combo box 1
Private Sub Combo87_AfterUpdate()
Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
Me.FilterOn = True
End Sub
Combo box 2
Private Sub cboMoveto_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[tblChild Care Providers_Vendor Number] = '" &
Me![CboMoveTo] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Okay now when I choose a month I want it stays in the box
then I choose the vendor number I want but when I hit enter the number in
the search box disappears. Is there a way to keep it there? Also, if I want
to save that vendor number and switch months is that possiable?
So I have the month I choose then I choose the vendor number
I also have the vendor number on my actual form when it finds the record.
Can I choose to see a different month using that vendor number?
Geez I hope this makes sense.
Thanks
For 2 combo boxex
Combo box 1
Private Sub Combo87_AfterUpdate()
Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
Me.FilterOn = True
End Sub
Combo box 2
Private Sub cboMoveto_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[tblChild Care Providers_Vendor Number] = '" &
Me![CboMoveTo] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Okay now when I choose a month I want it stays in the box
then I choose the vendor number I want but when I hit enter the number in
the search box disappears. Is there a way to keep it there? Also, if I want
to save that vendor number and switch months is that possiable?
So I have the month I choose then I choose the vendor number
I also have the vendor number on my actual form when it finds the record.
Can I choose to see a different month using that vendor number?
Geez I hope this makes sense.
Thanks