Automatic Data

[Heather]

I have a Access 2000 database.
I have one table with two fields Location and Section
I have 2 list boxes on a form - one for location and one for section

Is there a way to when the user selects from one of the lists, the
other list automatically updates as well?

[Wayne Morgan]

Yes, there is, but it may be difficult with the setup you have. You indicate
that you have one table with two fields. That would mean that there is a
one-to-one relationship between the two fields (they're each in the same
record) so if Record1 is selected for Location then Record1 would be
selected for Section. You don't need two listboxes to do this, you could
simply make one listbox with two columns.

To update one listbox upon the selection in another listbox, the
relationship is usually a one-to-many relationship. For example, the first
listbox would be a list of States. Then in the second listbox you would have
a list of Cities appear that are in the selected State.

--
Wayne Morgan
MS Access MVP
"Heather" <HW******@cox.net> wrote in message
news:cb**************************@posting.google.c om...

I have a Access 2000 database.
I have one table with two fields Location and Section
I have 2 list boxes on a form - one for location and one for section

Is there a way to when the user selects from one of the lists, the
other list automatically updates as well?

[Paul]

There is a simple way.

Lets call the 2 combo boxes on your form C1 and C2

Then on the OnEnter event of each combo box.:
for C1 enter: c1.requery
for C2 enter: c2.requery

This way every time you click on the field it will re-lookup its source.
"Heather" <HW******@cox.net> wrote in message
news:cb**************************@posting.google.c om...

I have a Access 2000 database.
I have one table with two fields Location and Section
I have 2 list boxes on a form - one for location and one for section

Is there a way to when the user selects from one of the lists, the
other list automatically updates as well?