DLookup problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Williams - 23 May 2007 12:11 GMT

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

Reply to this Message

Klatuu - 23 May 2007 14:05 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> I have a control on a form that has as its record source the following
> DLookup
[quoted text clipped - 6 lines]
> Thanks
> Tony

Reply to this Message

Tony Williams - 23 May 2007 15:01 GMT

Thanks but got #Error with that ?
Tony

> The reference to the form control has to be outside the quotes.
> =DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &
[quoted text clipped - 12 lines]
> > Thanks
> > Tony

Reply to this Message

Klatuu - 23 May 2007 16:08 GMT

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] & "'")

Signature

Dave Hargis, Microsoft Access MVP

> Thanks but got #Error with that ?
> Tony
[quoted text clipped - 15 lines]
> > > Thanks
> > > Tony

Reply to this Message