Dlookup #error #name

[Dazzle]

I have a form with a tab control which houses 3 subforms. On one of the
subforms I have a combo box from which I pick an id number. The field beside
it has a dlookup function that should return a description based on the combo
but I can't seem to get it to work. I have an ADP front end to sql2005
backend. I have tried the following:

=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] =
[comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] =" & forms![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = " &
forms![subform].form![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = form.[comboname]")


HELP!

 

[Joan Wild]

Is the comboname control bound to a text field or number? This link should
help you
http://www.mvps.org/access/general/gen0018.htm

 

[Klatuu]

The objects you are referencing to get the values to pass have to be outside
the quotes. It is also necessary to delimit the value being passed based on
the data type of the domain field:

Numeric version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = " &
[comboname])

Text version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = '" &
[comboname]) & "'"

Date version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = #" &
[comboname]) & "#"

 

[Dazzle]

Thank you. I used your text version but moved the ending quotes inside the
bracket.


--
Shelley

The objects you are referencing to get the values to pass have to be outside
the quotes. It is also necessary to delimit the value being passed based on
the data type of the domain field:

Numeric version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = " &
[comboname])

Text version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = '" &
[comboname]) & "'"

Date version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = #" &
[comboname]) & "#"

I have a form with a tab control which houses 3 subforms. On one of the
subforms I have a combo box from which I pick an id number. The field beside
it has a dlookup function that should return a description based on the combo
but I can't seem to get it to work. I have an ADP front end to sql2005
backend. I have tried the following:

=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] =
[comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] =" & forms![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = " &
forms![subform].form![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = form.[comboname]")


HELP!

 

[Klatuu]

oops!
correct syntax does make a difference

Thank you. I used your text version but moved the ending quotes inside the
bracket.


--
Shelley

The objects you are referencing to get the values to pass have to be outside
the quotes. It is also necessary to delimit the value being passed based on
the data type of the domain field:

Numeric version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = " &
[comboname])

Text version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = '" &
[comboname]) & "'"

Date version:
=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] = #" &
[comboname]) & "#"

I have a form with a tab control which houses 3 subforms. On one of the
subforms I have a combo box from which I pick an id number. The field beside
it has a dlookup function that should return a description based on the combo
but I can't seem to get it to work. I have an ADP front end to sql2005
backend. I have tried the following:

=dlookup("[description]", "tabletolookin", "[Fieldinlookuptable] =
[comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] =" & forms![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = " &
forms![subform].form![comboname]")
=dlookup("[description]", "tabletolookin", "[filtbl] = form.[comboname]")


HELP!