Hi,
I am using MS Access 2010 and have an issue with one of my forms.
First off, I have a table called coefficient which contains a column MIN, a column MAX, and a column COEFF.
In my form, called CALC, I want to grab a number that it is in textbox [Text12] and place the related coefficient number in textbox [Text15].
I placed a control source in [Text15] using =DLookup("[COEFF]","coefficient","[Text12]>[MIN] And [Text12]<[MAX]")
It is throwing an error when I run the form.
Any suggestions?