Solved

access forms

Posted on 2013-01-15
3
155 Views
Last Modified: 2013-02-05
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
Comment
Question by:topUKlawyer
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38778656
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
 

Author Comment

by:topUKlawyer
ID: 38800179
thanks might take me a few more days to test your answer please bear with me.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38800276
No worries
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
My experience with Windows 10 over a one year period and suggestions for smooth operation
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now