By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Automatically Fill Fields

P: n/a
When selecting a option from a drop down menu in the form view, which is
linked to a table with three columns, how do I get Access to automatically
fill in two other fields automatically once the first field is selected, and
by using the remaining two columns?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> When selecting a option from a drop down menu in the form view, which is
linked to a table with three columns, how do I get Access to automatically
fill in two other fields automatically once the first field is selected, and
by using the remaining two columns?


In the drop down's AfterUpdate event:

Me!MyCtrl2.value = Me!MyDropDown.Column(1)
Me!MyCtrl3.value = Me!MyDropDown.Column(2)

Columns are counted from 0.
Don't forget error handling.

Peter

--
No mails please.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.