When using the SQL Request Control, I am able to successfully connect to our database, and execute the query. When in preview mode, or after publishing the form, the control is failing to populate with any values.
Solved! Go to Solution.
I think 'Value field' and Display field' fields should refer to columns returned by SQL.
so either put there directly SQL column name (EmployeeNum) or populate Staff_ID reference with string 'EmployeeNum'
So how did you make the new sql statement, is it like
SELECT EmployeeNum AS Staff_ID FROM VW_viewname
Or you can try giving EmployeeNum as Display and value field
I made the Value and Display fields both EmployeeNum, displays on run now, but not on form:
Then I changed the control mode to Edit, but got the exact same results
could you try to rewrite your statement as follows:
select EmployeeNum as EID, EmployeeNum as EVal from ....
'Value field' to EID
'Display field' to EVal