AfterEvent Macro

[Meesh]

I am trying to create an AfterEvent macro for a form so that when you select
a device, it will then in the next combo box populate the ports associated
with that device. can someone quickly explain how to set up the argument for
this macro?

Thanks

 

[Al Campagna]

Meesh,
Given that you have cboDevice and cboPorts...
cboPorts should be using the value selected in cboDevice as a criteria
against it's associated ports.
Example query...
Device | Ports
=cboDevice

So... all that should be needed in the AfterUpdate event
of cboDevice is a Requery against cboPorts.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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