Hard time of it...

[zym1ne]

HI once again guy's and gal's

Slowly starting to get to grips with this creature called ''Access'' but a little snag has brought me up short again (not hard to do )

I'm stuck on how to create a form that will allow me to filter info populating a list box, using 2 txt boxes...?

Here it is:

List box populated with info taken from tblAdmin

Fields within tblAdmin:
AdminID#
AdminDate
DID#
Problem
Resolution
Status
Type

I've tried to work out how I would use multi criteria to filter info I require i.e:

txt filter 1 by Status =(open;closed;escalated)
txt filter 2 by Type = (hardware;software;network;install)

so as an example I would filter for all ''Installs'' that are ''Completed''...or all ''open'' ''software'' details

to cap it all off though the big scary boss guy has also suggested that we can look up the above info within a Date range aswell !!!!!!!!

just some pointers on how I might acheive the first hurdle would be great and a livesaver folks...

many many hugs and thank you's for any assistance

zym

 

[reel knotty]

Ok I don't know if this is the right way to do it (I am the king of half arsed programing) but I think it would work for you....

Create a "pop up" form with a [date start], [date end], [status]drop down, and [type]drop down.

Then create a button with an underlying macro the opens your main form



then your main form run off an underlying query:
fields " "Criteria
AdminID#
AdminDate " "=BETWEEN[form]![pop up]!date start and [form]![pop up]!date end

DID#
Problem
Resolution
Status " "[form]![pop up]![satus]
Type ' ' [form]![pop up]![Type]

 

[zym1ne]

thanks for this reel...

Thanks for the suggestions there Reel

will take me a little while to get my head round it but gonna give it a try and see what I come up with...

still pretty new to this programming lark but will let you know how it works out (if I manage it with my grey matter working overtime )

zym

 

[reel knotty]

shoot me an email if you run into a snag I would be happy to put a sample together for you

 

[jfgambit]

Assuming the textboxes are on the same form as the listbox, just chage the underlining row source to point at the textboxes...

Add the following to the criteria of the fields you want to filter:
[Forms]![NameofForm]![TextboxName]

Then add the following to the After Update event of the textboxes:
Me.ListboxName.Requery