Help!! Access Database

[Marty]

Someone please help!
I am attempting to create a database that will automatically place information
in [form] fields(2)and(3) based on a what a user selects from a pulldown
menu in field (1).
{Field one looks up the aforementioned data in a different table, named(t)
}
I don't want the user to input any info in fields (2) or (3)
I've tried everything! Any suggestions would be greatly appreciated! Thanks.
-Marty

[Michael]

Marty,

Have you tried using the "On Change" event coupled with VBA? The "ON CHANGE"
can be used to detect a change to the drop down list and fire off some VBA
code. The VBA would create a DAO object to read the "other" table to populate
the 2 other form fields.

Michael




"Marty" <Marty7@juno.com> wrote:
>
>Someone please help!
>I am attempting to create a database that will automatically place information
>in [form] fields(2)and(3) based on a what a user selects from a pulldown
>menu in field (1).
>{Field one looks up the aforementioned data in a different table, named(t)
>}
>I don't want the user to input any info in fields (2) or (3)
>I've tried everything! Any suggestions would be greatly appreciated! Thanks.
>-Marty