Yes, there is a way...
You need to create a form letting you choose the name of your table, import it through the module as a recordset, which has a property called columncount, or so...
You can also define the form's Source in the Properties, Data, ControlSource (or something like this, I don't know exactly, I'm using the french version)...
Have fun... :-)
Just found out what the problem was...
Opening and closing brackets were necessary...
Correct code is :
=DLookUp("[2004]","[LBA Account]","[LBA Account].[LBA_Compte] =" & Compte_N°)
Well, it is in a report, and I have both a checkbox and a provisory textbox (format yes/no) in it...
The result is Yes whether the field value is yes or no when the DLookUp criteria match a record and no when they don't...
When I try to get the value from a Yes/No field with a DlookUp function, the result I become is Yes if DLookUp is successful and No when criteria don't match any record ?
Does anyone know where this problem comes from ?
How should I do to get the value of the field ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.