filter form records

pyrohavoc · May 16, 2006

setting up a database for my department at work and have a few questions

Code:

a.) i need to set my form to have a search or filter based on user criteria

     1.) users need to be able to select themselves from a drop down list
          that's based on a table in order to filter their cases from everyone 
          elses

      2.) instead of using the drop down menu i'd like them to be able to enter
           an ID number that pulls up a specific record rather than first selecting
           all their cases and then navigating those until they come across the 
           case they're looking for

pyrohavoc · May 16, 2006

going to try to modify this to my form ... never messed with VB so we'll see how it goes

http://www.access-programmers.co.uk/forums/showthread.php?t=107282

pyrohavoc · May 16, 2006

ok i gave it a shot but i'm lost ... here's a screen capture of my form

basically i need two "search" features ... one that the user selects themselves from a drop down menu that will have the same choices as the drop down for case manager ... however i don't want to edit the current records case manager ... in effect, this selection would narrow all records to only those having a matching case manager

and the second "search" would be for a specific case by ID number ... i want the user to enter the case ID number and have that record appear within the same form

both of these features would be at the top of the form so that they are always available to the user

i guess i'd also need a reset feature ... i tried making modifying that search from the above post but i got lost ... some help would be appreciated

pyrohavoc · May 17, 2006

ok so far i've got my drop down based on the table that i wanted in my header ... i added a button with the following code

Code:

Option Compare Database

Private Sub Command76_Click()
  Me.Requery
  Me.Combo74.Requery
End Sub

Private Sub Command76_DblClick(Cancel As Integer)
 Me.Requery
End Sub

Private Sub Form_Open(Cancel As Integer)
  Me.Requery
End Sub

i edited that from the thread that i posted about before

when i click the button though ... nothing changes

basically my form shows one record at a time of x number of records ... i just want to narrow x based on case manager

help would be greatly appreciated

vangogh228 · May 19, 2006

I have EXACTLY the same issue.

I have a Form based on a Query. My Form opens to a new record. I would like to have the Query rerun (I think) and the Form refresh when a selection is made in a control at the bottom of the Form, and have that entry as an additional parameter in querying on the form. I don't want to use Filter by Form, as most of my users are neophytes to Access.

What I am hoping to do is have SEPARATE fields for 1)their name when they are inputting new records (this would be at the top, called "MyName") and 2)their name when they are trying to filter to their subset (in the form footer, called "FindMine").

THANKS for any help.

vangogh228 · May 19, 2006

Found It !!!

Look at this page. The answer is there !!

http://allenbrowne.com/ser-28.html

Look at the section called Simple Filter Example.

pyrohavoc · May 23, 2006

vangogh228 said:
Look at this page. The answer is there !!

http://allenbrowne.com/ser-28.html

Look at the section called Simple Filter Example.

thanks ... don't have time to work on it right now but i'll check it out in a bit and let you know how it goes ... finally someone offers help

vangogh228 · Jun 2, 2006

Did you ever get it to work? I tried it on mine, and it worked perfect.

filter form records

pyrohavoc

Registered User.

pyrohavoc

Registered User.

pyrohavoc

Registered User.

pyrohavoc

Registered User.

vangogh228

Registered User.

vangogh228

Registered User.

pyrohavoc

Registered User.

vangogh228

Registered User.

Similar threads

Users who are viewing this thread