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

"Meesh" <(E-Mail Removed)> wrote in message
news:933F8922-A382-4A28-A8E2-(E-Mail Removed)...
>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