Building a form in Access can filter specific records in a table

Question

Is it possible for an Access form to filter specific fields in the record source table so the user can deal with them only a part form the rest of the table fields?

The table contains many fields and the user needs to enter data in all fields for the different records in the table. To make it easy, I need to filter the records which have similar or are common in a specific character to enter their data, then remove the filter and put another filter for another character.

Edward Spring Edward Spring · Accepted Answer · 2013-10-10T20:46:00

Example solution:

Private Sub Form_Open(Cancel As Integer)

   Dim argsString As String, sFil As String

   argsString = Me.OpenArgs
   MsgBox "Incoming OpenArgs = " & argsString

   sFil = "SpecGrpID = " & argsString
   Me.Filter = sFil
   Me.FilterOn = True

End Sub

Building a form in Access can filter specific records in a table

2 Answers