cascading combo boxes

[shaz0503]

Hi all

The novice again.

I would like to be able to create some cascading combo boxes within a data
entry form. The options within the boxes would be pre set. What I would
like tohappen is in the first data entry field the operator selects the query
group and dependant on this selection are the options for the second data
entry field.

i have searched to forum but as not savvy with access yet - there seems to
be many ways of oing this - I need to keep it simple.

TIA

Shaz

 

[Al Campagna]

Shaz,
On my website (below) under Access Tips, I have a sample Access97 and
Access2003 sample file called "Synched Comboboxes"
It shows how to use the value from a first combobox to filter the query
results of a second combo.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[account]

Hi all

The novice again.

I would like to be able to create some cascading combo boxes within a data
entry form. The options within the boxes would be pre set. What I would
like tohappen is in the first data entry field the operator selects the
query
group and dependant on this selection are the options for the second data
entry field.

i have searched to forum but as not savvy with access yet - there seems to
be many ways of oing this - I need to keep it simple.

TIA

Shaz