My plan is to create a query based on the new field names/table name, and then replace the current Row source with that.(the field and table names have been changed using VBA already)
This is some code for an existing combobox on a form to change it to a query.
Expand|Select|Wrap|Line Numbers
- Forms!Employees!cmboNames.RowSourceType = "Table/Query"
- Forms!Employees!cmboNames.RowSource = "EmployeeList"
I want to change the sql in the original table to a query name but leave the rest of the properties and sizes the same. Is it possible?