Form with datasheet view

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a table with a list of products and a yes/no field (checkbox to be
exact). What the purchasing clerk does is go down the list and puts a check
mark on the items to be purchased. I then have an append query to select and
append the items to another list. This works fine but my only problem is
that I dont want the user interacting with the datasheet. Is there a better
way to accomplish this task? I take any suggestions
 
You can create a form that gives the user only those capabilities that you
want him to have. The datasheet view is a quick-and-dirty way to access
table data and I avoid using it whenever possible because it gives the user
too much opportunity to corrupt his data. The datasheet view can only
enforce a very limited set of validation rules. If your user should only be
toggling a check box, then that's the only field that should be enabled on
the form that you create.


Bill Nicholson, Access Dufus
 
Back
Top