Hello,
I am trying to rebuild the Query-by-Form menu function in order to have it working in a runtime version.
I try to run through my controls-collection of the form and add all the user inputs to one filter criteria. In order to do that I have to check, whether the datatype of the control is dbText, dbLong or dbBoolean. How can I do that.
Here part of my code:
for each ctl in frm1
if ??? = dbText then
strFilter = strFilter & " AND " & BuildCriteria(ctl.Name, dbText, ctl.Value)
else
if ??? = dbLong then
strFilter = strFilter & " AND " & BuildCriteria(ctl.Name, dbLong, ctl.Value)
else
I am trying to rebuild the Query-by-Form menu function in order to have it working in a runtime version.
I try to run through my controls-collection of the form and add all the user inputs to one filter criteria. In order to do that I have to check, whether the datatype of the control is dbText, dbLong or dbBoolean. How can I do that.
Here part of my code:
for each ctl in frm1
if ??? = dbText then
strFilter = strFilter & " AND " & BuildCriteria(ctl.Name, dbText, ctl.Value)
else
if ??? = dbLong then
strFilter = strFilter & " AND " & BuildCriteria(ctl.Name, dbLong, ctl.Value)
else