How can I make a connection between a drop down list and a command

H

Henry

I created on Access Database a simple switchboard that can go to different
people and this people can select an update form or view a report based on
their update form. Now I am going to add one more option that makes person be
able to select his name and by clicking his name (from a drop down list) his
report pops up.
I used a combo list on a form and brought list of people's name and then I
made a command button, whenever user press it it 's supposed to go to this
person 's report
but it doesn't go there is no connection between this drop down list and
action button how can i do it
 
B

bhicks11 via AccessMonster.com

Hi Henry,

Add the action to the OnExit event of the combobox. You can either run a
macro or use VBA to open the form and filter on the person. If you have
trouble getting it going, drop a note with what you have done.

Bonnie
http://www.dataplus-svc.com
 
L

Linq Adams via AccessMonster.com

You could use the AfterUpdate event to open the form and filter using its
value, but you do not want to use the OnExit event! This would fire anytime
the user tabbed thru the combobox, whether a name had been chosen or not!
 
B

bhicks11 via AccessMonster.com

I see your point. I use the AfterUpdate from a batch form (its only purpose
is to key the batch info for data entry) that opens a form filtered because I
actually do want to open the form every time the user moves off the combobox.

Bonnie
http://www.dataplus-svc.com
 
Top