I have a valid query in MS Access which pulls data from a linked table. But when I use this query as a row source for a combo box in a form, no data is pulled and the list is empty. What can be the problem?
GROUP BY tbl_activityList.ActivityCategory;
Simple.. I just modified the SQL query. Instead of
[Forms]![frm_everydayTasks]![lbl_teamName] I used
Me.lbl_teamName.Caption and its working fine. Thanks.