Combo List Problems

  • Thread starter Thread starter Jgarcia2k3
  • Start date Start date
J

Jgarcia2k3

I’ve used this forums many times and its answered 100% of my question
either by looking at past posting or getting replies, I just want t
say this is the definitive place to look for any Access questions.

I am having problems with my form. I have 3 Combo Boxes, Client Name
Jurisdiction and Form Type. These are the main components of a Contro
Log Table that users have already entered in data.

What I am trying to accomplish is have users pick a client, then hav
Jurisdiction populate the valid jurisdictions based what users hav
entered into the Control Log Table, then have users click on form typ
which was populated on the jurisdiction combo box.

After that, the rest of the due dates, and any comments that wa
entered would populate by themselves. I can have users hit a refres
button if necessary

As always your help is appreciated

Jua
 
Hi Juan,

You don't say what problems you are having.
From your description it sounds like you may be doing the right things, but
it is not clear.
If you give a little more details maybe I could help. For example, what
determines which jurisdictions are to be listed in the Jurisdictions combo?
What info is in the Control Log Table? How does the client fit in. e.g. does
selecting a client determine any other data?

Ragnar
 
Sorry about that, I've narrowed things down to 2 combo boxes, In th
control log table the client determines the jurisdiction and form type
that I've setup the second combo box based on that query thats runne
after the update, my only problem is that on that second combo box
want a user to pick the jusrisdicion and form type and then go to tha
record on the form.

I have a field called "Go_To" that stores the results of what the use
picks, I'm just having a hard time figuring out to use that to make th
user go to that recor
 
Problem solved. For the inquiring minds, here’s the solution. I create
an advanced filter based on the Control Log Form, (I’ve just notice
the whole time I’ve been saying table on this thread, my apologies
meant form). I based the search criteria on the form with the fields
needed (Client and Jurisdiction). From there I created a macro, whic
selected my object, applied the filter. Then I went back into m
Control Log Form assigned a command button to the macro. There you hav
it, sometimes the most complex problems have the easiest solutions
 
Back
Top