Forum Discussion
ADGToreUp
Feb 15, 2023Brass Contributor
Check Box to archive items on a form, that has a list used in a combo box in main form.
Hello everyone, I have a main form with a combo box for employees to select their option they need for that record. On the "Sub" form that feeds this comb box, I have a field with a check box op...
George_Hepworth
Silver Contributor
SHow us the table please. Screenshots are nice, but not sufficient.
ADGToreUp
Feb 23, 2023Brass Contributor
I was able to solve my issue. I should have updated this. Thank you though. I made a new column in SQL server as "Archive" "Bit". then once link refreshed in Access, i added a WHERE statement to filter out based on a 0 or 1.