Tech Support Tracker

[kit_sune]

In my office we often get requests from higher ups about the support we've supplied to our customers. We try to keep track in Excel, but this is such a primitive way of doing things, and I would much rather use Access.

Rather than explaining the whole situation I'm going to just dive into the issues (one at a time).

I have a form called "Tech Support Hub" which acts as a portal to lead into other forms/manipulate the type of data the user is limited to inputting/searching. This form has several radio and toggle buttons that will do these actions.

The first, a toggle button group, has a button for each section of our office. "Analysis" and "DBM" or Database management.

What I want to do first is have it so when a user clicks on one of these buttons and then proceeds to the Request_Tracker form, the Request Types (Req_Type) are limited to only those that are applicable, based on a "Request_Type" table that I have.

In other words, if I click the DBM button and then click on my Tech Support Tracker button to go to the next form, when I am helping a customer and I click on the “Request Type” dropdown menu I have there, I want it to limit the available options based on what I clicked previously.

Does this make sense?
Thanks for any shred of help you can provide.

 

[Mr. B]

The way I normally do somthing like you are describing is:

Use VBA code in the OnOpen event of the next form to generate the appropriate SQL statement and then apply that sql statement as the row source for the form. This sql statement can provide the criteria that will limit your records to the apprpriate filtered list.

As you start to do this and run into more specific questions please post back and someone will try to help.