Hi all,
So i need to run an update query to un-allocate from one user to another
form has two comb boxes - so user name can be selected
From
To
Query has
to: [Forms]![Reallocate].[To]
criteria [Forms]![Reallocate].[From]
no records are found when calling from form, but if i run query and enter names it works fine?
Update - OK so if i convert the combo box to text box it works - shame as wanted to use the combo box select user list
So i need to run an update query to un-allocate from one user to another
form has two comb boxes - so user name can be selected
From
To
Query has
to: [Forms]![Reallocate].[To]
criteria [Forms]![Reallocate].[From]
no records are found when calling from form, but if i run query and enter names it works fine?
Update - OK so if i convert the combo box to text box it works - shame as wanted to use the combo box select user list
Last edited: