Filter in a form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Filter in a form

Mark Wright

5 years ago

Hi all,

I'm trying to add a filter in to a continuous Form. The form derives its data from a Query, and the Form cannot be edited by the user, but is a list of all active customers. However there is a list of names of who the customers belong to and I am trying to add a filter in the Form so the user can choose their name then instantly see which customers belong to them.

Could you point me in the right direction, as I'm not sure if I have to use VB or create a ComboBox within the form or both.

Any help would be appreciated.

Many thanks

Mark

	Kevin Robertson @Reply 5 years ago
Create your ComboBox of names and enter the following code in the AfterUpdate event `Me.Filter = "[YourID]=" & ComboBoxName Me.FilterOn = True` YourID will be a Foreign Key in your Customer Table.

	Kevin Robertson @Reply 5 years ago
To avoid an error when the box is cleared: `If Not IsNull(ComboBoxName) Then Me.Filter = "[YourID]=" & ComboBoxName Me.FilterOn = True Else Me.FilterOn = False End If`

	Mark Wright OP @Reply 5 years ago
Hi Kevin, thank you for this and apologies for the late response as It's been crazy in my day job! Okay, I have done this, and the list of names are in the combo box - however when I click the dropdown box it does show the list of names but it will not let me select a name. When I click on the name nothing happens. Any assistance would be appreciated.

	Kevin Robertson @Reply 5 years ago
Sounds like the Recordset is Not Updateable

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View