i am making a stock control system in MS access 2000. Currently i am developing a form which will be used to order the stock which is low.
currently i have a main form with a subform on it which shows a list of all the products which r below the specified limit. the list is a datasheet view populated by a query.
Now what i want to do is to have some kind of facility to pick items from that list as i dont want to order everything which computer suggested. what i am thinking is to have a checkbox before every record in the datasheet view which can allow me to pick items from that list & then put the selected records into another table.
Can anybody plz help me.i have no idea how to actually do this.