Change to CheckBox Option

Hello All,

Can you help me Change the “ShipName” field in the form to a checkbox instead?

Like a checkbox with “Jones” – when user click on it, it filters the subform by Jones?
Is that at all possible within the access limitations?

Sorry have something that due in few hours from now...
finalTestPleaseRev101.accdb
RayneAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
By the way, there are no "Jones" records in the data in this file...

but look at the code in the checkbox's click event and change the text if needed:

Private Sub chkJones_Click()
    If Me.chkJones = True Then
         Me.frmSource.Form.Filter = "[Ship Name] Like '*Jones*'"
         Me.frmSource.Form.FilterOn = True
    Else
        Me.frmSource.Form.FilterOn = False
        Me.frmSource.Form.Filter = ""
    End If
End Sub

Open in new window

0
 
Rey Obrero (Capricorn1)Commented:
that is possible, but you will have a lot of checkboxes..


do you still want it?
0
 
mbizupCommented:
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
RayneAuthor Commented:
Awesome, that works like a Charm :)
Thank you
0
 
mbizupCommented:
Thats a great article!   If you have done so yet vote yes at the bottom of the article and post a reader comment.
0
 
RayneAuthor Commented:
thanks  mbizup, done :)
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.