General information
Category:
Forms & Form designer
Title:
Missing Field in Combo ListBox
Okay, here's a fun one for you guys and gals. While trying to create a data entry form for employees' time, I ran into a gliche that is frustrating to say the least. On this form, there is a dropdown listbox that displays pre-sorted tasks for various departments. The data is sorted through the following SQL statement:
**gcDept is a variable selected from a dropdown combo on the same form
SET SAFETY OFF
SELECT Str_task.code_num, Str_task.descriptio;
FROM fdms!str_task;
WHERE gcDept = Str_task.dept;
ORDER BY Str_task.code_num;
INTO TABLE H:\VFP\FDMS\DATA\DATAQUERY\QWhodaddy.dbf
SET SAFETY ON
The resulting data in the dropdown listbox contains only the tasks that apply to the department that was entered earlier (gcDept). However, only the first (str_task.code_num) is displayed; the second (str_task.descriptio) is not visible even though the combo builder shows otherwise. Also, to add further entertainment, if we select the department three times then the str_task.descriptio finally appears. I say whassup wit 'dat? Any help or comments would be appreciated. I've spent the day on it and my head is fried. Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only