Can I change the default value of a control?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Williams - 23 May 2007 15:17 GMT

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

Reply to this Message

Carl Rapson - 23 May 2007 17:36 GMT

>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
[quoted text clipped - 9 lines]
> 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

Reply to this Message

Tony Williams - 23 May 2007 19:28 GMT

Thanks Carl
Tony

>>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
[quoted text clipped - 20 lines]
>
> Carl Rapson

Reply to this Message