Can I use checkboxes on a form to select columns?

D

dbaggett

I have to enter data evryday that has a different set of rejects daily. There
are about 15 different rejects that can be used but there might be 5 or 8
used in a given day. Could I set up a form so I could select the rejects
(columns) I need to key data into, then open a datasheet or form with only
those coulmns showing? I know the rejects I need for each day and this seems
like it would make it easier to key in the data.
 
D

dbaggett

OK, Can I use a list box to create a SQL to open a query to key in the data.
If so how do I cycle through the list to get the rejects(column names). I've
made the listbox and can loop through but need to pull the string form of the
rejects from list.
 
Top