• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

access forms

Tables:

Clients have many Files
Each file has one Employee assigned.

Forms are Clients with a subform for Files.

How would I best place a filter for filtering records based on combo box of all Employees/named employees and if based on a query how would I design that.

I already have an employeess table. and a files subform as set out above
0
topUKlawyer
Asked:
topUKlawyer
  • 2
1 Solution
 
mbizupCommented:
Try placing an unbound  combo box in the header of your Clients form selecting employee names and with employee ID as the bound column, and in the After Update event of the combo:


dim rs as DAO.recordset
Set rs = me.RecordsetClone

rs.FindFirst "ClientID = " & Me.cboClientSearch
if rs.NoMatch = true then
     msgbox "No Match found"
     exit sub
end if

Me.Bookmark = rs.bookmark
set rs = nothing

Open in new window

0
 
topUKlawyerAuthor Commented:
thanks might take me a few more days to test your answer please bear with me.
0
 
mbizupCommented:
No worries
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now