Can I change the default value of a control?

[Guest]

I have a form which has a number of controls where the control source is a
DLookup statement, eg the value of txtSurname is a DLookup which compares a
membership number on the form with the membership number in a table and then
returns the equivalent surname. However there are times when I don't have a
membership number but still want to input a surname but when I click in the
surname control I can't enter any text. The form is based on a query which
links two tables. can anyone tell me a way around this?
Thanks
Tony

 

[Carl Rapson]

I have a form which has a number of controls where the control source is a
DLookup statement, eg the value of txtSurname is a DLookup which compares
a
membership number on the form with the membership number in a table and
then
returns the equivalent surname. However there are times when I don't have
a
membership number but still want to input a surname but when I click in
the
surname control I can't enter any text. The form is based on a query which
links two tables. can anyone tell me a way around this?
Thanks
Tony

What I would do is remove the DLookUp from the Control Source of the control
and put it in the Form_Current event instead:

Me.txtControl = Nz(DLookUp(...),"")

That way, the value is set whenever a record is displayed, but you can also
type in your own value.

Carl Rapson

 

[Tony Williams]

Thanks Carl
Tony

What I would do is remove the DLookUp from the Control Source of the
control and put it in the Form_Current event instead:

Me.txtControl = Nz(DLookUp(...),"")

That way, the value is set whenever a record is displayed, but you can
also type in your own value.

Carl Rapson