I need help. My app is a timekeeping/scheduling app. I have a table that contains all the employee clock numbers of my department. I have another table that collects data as the employee starts inputing their hours. When the employee turns in their timesheet the administrator looks at a list of all the employee's and starts clicking the ones turned in. This in turn sets a flag in the second table indicating the timesheet is complete. I have the list box reseting it's rowsource as the items are clicked but for some reason my SQL statements are not coded correctly because it still pulls up all the numbers again. My SQL statements are:
Select badgeno From second table Where complete = .T. Into Cursor
Select badgeno From first table Where first.badgeno <> second.badgeno
What am I doing wrong?