Hi experts,
I am new to Outlook forms and am creating my first. I need to populate a dropdown on the Outlook form with a recordset that is the result of a query found in an Access 2K db.
In Access, I could just go:
But something like that is a no-go in Outlook.
So, although the rowsource property is available in the Outlook properties for the dropdown, I cannot get it to work as I do not now how to set the rowsource. Do I set the rowsource within the View Code/VBScript? Or, do i create a sub/function? And if so, how the heck to I call it, and from where?
If anyone has any comments or code re: this issue, it would be greatly appreciated...
Thanks,
Jeff G
I am new to Outlook forms and am creating my first. I need to populate a dropdown on the Outlook form with a recordset that is the result of a query found in an Access 2K db.
In Access, I could just go:
Code:
cboDropDown.RowSource = GetSQL()But something like that is a no-go in Outlook.
So, although the rowsource property is available in the Outlook properties for the dropdown, I cannot get it to work as I do not now how to set the rowsource. Do I set the rowsource within the View Code/VBScript? Or, do i create a sub/function? And if so, how the heck to I call it, and from where?
If anyone has any comments or code re: this issue, it would be greatly appreciated...
Thanks,
Jeff G
