Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • 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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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