AfterEvent Macro

  • Thread starter Thread starter Meesh
  • Start date Start date
M

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
 
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."
 
Back
Top