Help with Microsoft Access

[archcommus]

I am creating some data access pages for my Access project. I already have a query that pulls up data for either a specific member or all members, and a report that is backed by that query. I am trying to make a data access page that resembles this report exactly. So, when I add all the fields of the query to the page and move them around nicely, it looks good, but you have to deal with that Enter Parameters box to input the member you want and the date range. I'd like to get away from that by choosing this information with drop-down boxes, so it looks better on a website. Any ideas on how to accomplish this?

Thanks!

 

[KLin]

So you want combo boxes that have a data source coming from a reference table? When they select a member, you want the detail portion of the page to go to that specific record?

 

[archcommus]

Originally posted by: KLin
So you want combo boxes that have a data source coming from a reference table? When they select a member, you want the detail portion of the page to go to that specific record?

Sort of on the right track. I do want a combo box that has a data source coming from a reference table, specifically a table of two-week date periods and their associated ID numbers so they can choose a date period range. I then want to show ALL records pertaining to the current member from that date range they chose. In the query that I'm getting these fields from, these inputs are supplied by a form and it works nicely. I would just like my data access page to be thought of as the "form" in this case to supply that data instead of encountering an "Enter Parameters" box.

For the member selection, that is a little more difficult. Only one user will be logged into this website and viewing this information at a time, and I only want the report to show records for that user - I don't want them to be able to make a choice to choose other members or all members. But to figure that out I first have to know how to fetch such information from the domain they are logged into, I have to ask my employer about that one.