C
Clare
I currently have 2 comand buttons on my form which print different reports.
I'd like to now have them in a listbox instead.
Fredg has answered someone elses question by telling them to do this
As Rowsource of a list box or combo box:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;
Code the Combo or List box AfterUpdate event:
DoCmd.OpenReport Me!ComboName, acViewPreview
The problem is that after inserting the rowsource bits into the sql window I
press run and get the message "Undefined function 'Left' in expression".
I'm using access 2000. Does anyone know what I've done wrong?
Thanks.
I'd like to now have them in a listbox instead.
Fredg has answered someone elses question by telling them to do this
As Rowsource of a list box or combo box:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;
Code the Combo or List box AfterUpdate event:
DoCmd.OpenReport Me!ComboName, acViewPreview
The problem is that after inserting the rowsource bits into the sql window I
press run and get the message "Undefined function 'Left' in expression".
I'm using access 2000. Does anyone know what I've done wrong?
Thanks.