Form DMin Code

[xmeb]

The following code returns "#Name?" and I can't figure out what is wrong with it.

=DMin("[RoadNumber]","ResidencesSpecificTable","[RoadName] Like '*" & ME.ResidencesSpecificFormRoadNameTextBox & "*'")

 

[dhookom]

If that is a control source, get rid of the Me.

=DMin("[RoadNumber]","ResidencesSpecificTable","[RoadName] Like '*" & ResidencesSpecificFormRoadNameTextBox & "*'")

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

Duane:

That was it! It works fine now.

Thank you very much,

xmeb

 

[Andrzejek]

xmeb, you are here at TT for a few months now, and I hope you get some good answers to your problems. Yet you did not show any recognition of appreciation to anybody who helped you by clicking on
[blue]
Like this post?
Star it![/blue]

This little action says: Thank you, as well as marks the post as helpful so others can easily find it, too.


Have fun.

---- Andy