jhp
|
| Posted: 04/28/2003, 12:22 AM |
|
I am trying to sort my listbox, according to the help file you can use the Before Build Select event. When I try it in the task example it works.
But in my application I get the following error:
Source: ListBox State
Error description: No value given for one or more required parameters. (Microsoft JET Database Engine)
SELECT * FROM lstate ORDER BY state_name ASC
I find this error message to be VERY general. I have spelled the field name incorrect on purpose and still get the same message.
The database is an access table:
table name = lstate
state_id = autonumber
state_name = text (2)
Tee listbox is set up as required and I compaired all of the setting with the task example that works.
my code is:
Function Speaker_State_DataSource_BeforeBuildSelect() 'Speaker_State_DataSource_BeforeBuildSelect @13-10D73FFF
'Custom Code @36-73254650
' -------------------------
Speaker.State.DataSource.ORDER = " state_name ASC"
' -------------------------
'End Custom Code
End Function
Thanks for any help, I've wasted 4 hour on this.
|
|
|
 |
L Irving
|
| Posted: 04/28/2003, 12:54 AM |
|
Try changing
Speaker.State.DataSource.ORDER = " state_name ASC"
to
Speaker.State.DataSource.ORDER = state_name & "ASC"
|
|
|
|
jhp
|
| Posted: 04/28/2003, 1:02 AM |
|
Didn't work you can even the DESC or ASC out and still get the error.
|
|
|
|
|
