S
SirPoonga
I am gettinga n error box:
Run-time error '2176':
The setting for this property is too long.
I am generating a sql statement, it is rather large. The code has been
working but I recently had to make a structure change.
I am making a custom filter form. Based on selections form drop down
boxes I generate a SQL statement then assign the following RowSource to
it.
Me.sfResults.Form.RecordSource = sqlcmd
The subform is just a form in datasheet view to output the results of
the filter.
Putting a bookmark at that line in the Immediate Window I types 'print
sqlcmd'. I copied the command to a query builder. The query builder
ran it just fine.
So is there a text limit for rowsource? Anything I can do about it?
Run-time error '2176':
The setting for this property is too long.
I am generating a sql statement, it is rather large. The code has been
working but I recently had to make a structure change.
I am making a custom filter form. Based on selections form drop down
boxes I generate a SQL statement then assign the following RowSource to
it.
Me.sfResults.Form.RecordSource = sqlcmd
The subform is just a form in datasheet view to output the results of
the filter.
Putting a bookmark at that line in the Immediate Window I types 'print
sqlcmd'. I copied the command to a query builder. The query builder
ran it just fine.
So is there a text limit for rowsource? Anything I can do about it?