Can I use checkboxes on a form to select columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign a Table field a value from a form 1
Do I need to solve this with VBA record set? 11
Getting the total yields 1
Subforms 4
Create a work flow form(s) using desktop application 2
Question on Query 2
Mulitple users for a database 3
make a table of invalid records in access 3

Back
Top