DLookup problem

[Tony Williams]

I have a control on a form that has as its record source the following
DLookup
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=Forms![frmcomplaint].[txtmemnbr]")

Although this seems to work when I look at the form in design mode there is
an asterix against the control and the message is Invalid Control
Property:Control Source and it also says Circular reference. Anyone tell me
what might be wrong?
Thanks
Tony

 

[Guest]

The reference to the form control has to be outside the quotes.
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &
Forms![frmcomplaint].[txtmemnbr] & "'")

The syntax above assumes [txtfirstname] is a text field.

 

[Guest]

Thanks but got #Error with that ?
Tony

The reference to the form control has to be outside the quotes.
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &
Forms![frmcomplaint].[txtmemnbr] & "'")

The syntax above assumes [txtfirstname] is a text field.

--
Dave Hargis, Microsoft Access MVP

I have a control on a form that has as its record source the following
DLookup
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=Forms![frmcomplaint].[txtmemnbr]")

Although this seems to work when I look at the form in design mode there is
an asterix against the control and the message is Invalid Control
Property:Control Source and it also says Circular reference. Anyone tell me
what might be wrong?
Thanks
Tony

 

[Guest]

That is an unusual record source for a form. It will return only one field
of one record. Is it that what you really mean is a control source for a
control? If so, I have found that it works better like this:

=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &
[txtmemnbr] & "'")

--
Dave Hargis, Microsoft Access MVP

Thanks but got #Error with that ?
Tony

The reference to the form control has to be outside the quotes.
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &
Forms![frmcomplaint].[txtmemnbr] & "'")

The syntax above assumes [txtfirstname] is a text field.

--
Dave Hargis, Microsoft Access MVP

I have a control on a form that has as its record source the following
DLookup
=DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=Forms![frmcomplaint].[txtmemnbr]")

Although this seems to work when I look at the form in design mode there is
an asterix against the control and the message is Invalid Control
Property:Control Source and it also says Circular reference. Anyone tell me
what might be wrong?
Thanks
Tony