HELP!!!!

[Meghan]

Hi.
I'm new to Access and VBA, so please bear with me. Here's what I
would ideally like to do with my database, and I need to know if it's
possible, and if so, how to accomplish it. I would like the users to
be able to click on combo boxes to select a Task Name. After a Task
Name has been selected, the next combo box with drop down with a list
of Task Phases for the user to select from. Once a Task Phase is
selcted, the user will select a Deliverable from a list of
deliverables assigned to that Task Name, for that Task Phase.

I have somewhat accomplished what I'm looking for, but not fully. I
have all the criteria in unbound fields on a form. The selection is a
drill-down process, but now that I have the criteria I want, I want to
view the other information related to the specific criteria. I want
this process to be available for all forms or queries I have, since
this is the central basis of my database. Does anyone have any idea
if this is possible? Would a query be my best bet? I just couldn't
figure out how to get the parameter query to display as a combo box
and allow for new entries. I want to be able to search from one
table, then add additional information to related tables. PLEASE
HELP!!!!! I'm lost!

Meghan

 

[Pavel Romashkin]

I think it is possible. To do this, I think it is the simplest to create
a couple of related lookup tables. One should contain your Tasks. Other
should contain your Phases, related to Tasks by TaskID. Next, you need a
Deliverables table, related to Phases by the PhaseID.
Next, you will use
SELECT TaskID, TaskName FROM Tasks
as row source for cbTasks, and
SELECT PhaseID, PhaseName FROM Phases WHERE TaskID = Forms!MyForm.cbTasks
as row source for cbPhases, and
SELECT DelivID, DelivName FROM Deliveries WHERE PhaseID = Forms!MyForm.cbPhases
as row source for cbDeliveries.
All cbs need to have 2 columns, and their widths should be 0";1" or so.
To add new data to the tables you will use AfterUpdate events of the
combos. Let's get to this once you get the cascading lookup working.

Pavel

 

[John Vinson]

I have somewhat accomplished what I'm looking for, but not fully. I
have all the criteria in unbound fields on a form. The selection is a
drill-down process, but now that I have the criteria I want, I want to
view the other information related to the specific criteria. I want
this process to be available for all forms or queries I have, since
this is the central basis of my database. Does anyone have any idea
if this is possible? Would a query be my best bet?

Yes. Base your Forms and Reports (you can do queries too, but I do not
recommend letting users see any query or table datasheets!) on Queries
using

=Forms![yourformname]![controlname]

as criteria. You might want to make your unbound form a home-made
switchboard, by putting a Listbox on it with the forms and reports you
are offering; you can download a sample of such a switchboard from the
Files library in the CompuServe forum in my signature. It's free,
though you'll need an ID and password.

 

[Meghan]

Pavel,

Thanks for getting back to me. I think I already have what you are
directing me to set up to an extent. It's just that the TaskID,
PhaseID, and DelivID are all part of a table that has a CDRLID. We
have a CDRL table that encompases all of that information. I have
unbound fields in my form, and they work properly. I would just like
to make this set-up a uniform selection form. For instance, If I am
entering information on my Transmittal Form, I'd like to make a button
that will send me to the Task Detail Selection Form, then once my
selections are made, carry the CDRLID (which will contain all of the
task detail information) back to the Transmittal Form. there are
other forms I'd like to use it for as well. IS there any way to
bounce back and forth using one for a selection form, and the other as
the binding of information form? Thanks so much for your help!
Meghan

 

[Meghan]

Pavel,

Thanks for getting back to me. I think I already have what you are
directing me to set up to an extent. It's just that the TaskID,
PhaseID, and DelivID are all part of a table that has a CDRLID. We
have a CDRL table that encompases all of that information. I have
unbound fields in my form, and they work properly. I would just like
to make this set-up a uniform selection form. For instance, If I am
entering information on my Transmittal Form, I'd like to make a button
that will send me to the Task Detail Selection Form, then once my
selections are made, carry the CDRLID (which will contain all of the
task detail information) back to the Transmittal Form. there are
other forms I'd like to use it for as well. IS there any way to
bounce back and forth using one for a selection form, and the other as
the binding of information form? Thanks so much for your help!
Meghan

 

[Pavel Romashkin]

Meghan,

There is definitely a way of going back and forth between forms while
retaining the record selection of one of the forms. In fact, you don't
even need to specifically start from one form and go to another - you
can have each form simply look up the current value in the main form (I
am guessing, it is your Transmittal Form).
I am a little lost as to what exactly you are trying to do because first
you asked how to do a cascading lookup, and now you seem to ask how to
pass record IDs along. Am I missing the real point? I guess I am not
quite clear about what you mean by "a uniform selection form".
If you post the table structure (field names, PKs, related tables) and
what you want your forms to do, it will be best, I think.

Pavel