Displaying info within forms....

[zym1ne]

Hi there folks...

Had some invaluable help so far from this great forum, as a newbie trying to muddle my way through with no prior knowledge of access or programming, so have to say a BIG Thank-you to all the peeps who have offered assitance so far

Have searched through forums so far and still have a problem with displaying the info I want within a form though...

i.e:

tblDEAdmin fields = DID#, Date, Status and Tech type
tblRequests = Rep, Date and DID#

Now for quick viewing purposes of all work carried out I've tried and failed to create a form that will allow me to select various info and show it in a form view...

in the DE Admin tbl the Status field is a list box (install, open, closed. escalated) my problem so far is trying to figure a way of displaying all ''installs'' within a certain date range...

however I could also require a list of all Requests for a particular DID# (pri key) within a specified date or requested by a particular Rep...

I thought I might need to create a form with Multi-combos that could then filter through my selection, but I've only managed to create a form that produces a single record at a time, what I'm after is a form capapble of displaying multi-entries, because a DID# can have many Requests or many entries in the Admin table??????????

If anyone could lend a helping hand here that would be great as this is driving me mad

Many, many thanks in advance

zym

 

[zym1ne]

A thought occured...

Well no luck so far...however a thought has occured it might be easier for me to populate a list box with the particulars I require, or is this over complicating things slightly????

What I mean is would it be possible to create certain queries that would produce the forms I require, then have a form with a list box populated with these queries?

Then with the aid of 1 or 2 combo boxes I could specify which info I require, by DID# or date-from/to fields or Reps name...?

2 points here really though

1. Is this just over complicating things
2. How would I set about doing this



well have to admit this hasn't been a simple process, and hopefully any access jedi's out there might have some pearls of wisdom relating to what will be the best course for me to follow.

Thanks a million for any and all feed back on this one folks

zym