default value

[akl]

How can I create such a default value that it depends on the value in
other field (drop down)?
So that the default value would be updated every time I change the value
of drop-down field.

[Wayne Morgan]

While you can do this, the thing to remember is that the Default Value won't do anything
until you next move to a New Record. If you want the drop down to change the value
displayed in this field for the current record, changing the Default Value won't do this
for you. You simply have to set the value of the control.

In the AfterUpdate event of the drop down set the value or default value of the other
control.

Me.txtOtherControl = Me.cboMyComboxbox
or
Me.txtOtherControl.DefaultValue = Me.cboMyCombobox

This will set the value or default value of the textbox to the value of the bound column
of the selected row in the combo box.

--
Wayne Morgan
Microsoft Access MVP
"akl" <akl@no_spam.com> wrote in message news:3FB4BE6A.9080504@no_spam.com...

How can I create such a default value that it depends on the value in
other field (drop down)?
So that the default value would be updated every time I change the value
of drop-down field.

[Pieter Linden]

akl <akl@no_spam.com> wrote in message news:<3FB4BE6A.9080504@no_spam.com>...

How can I create such a default value that it depends on the value in
other field (drop down)?
So that the default value would be updated every time I change the value
of drop-down field.

http://www.mvps.org/access/forms/frm0028.htm