Mass Append using check boxes

[brow1726]

I am somewhat new to access but have a general understanding. My question is I am creating a database to track PTO. I have fields such as date, type, start, end, hours used etc. I also have a field for name. What I would like to do is use check boxes on the bottom that are attached to a name that will create multiple records so that I can update multiple people at one time. For holidays or alot of people leaving early for some reason. Any help would be greatly appreciated!!!

[pbaldy]

I'd use a listbox of names, which would be more dynamic.

http://www.baldyweb.com/MultiselectAppend.htm

[brow1726]

Ok so I tried the ListBox and when I go to run the append query it will save multiples. Like *2 of them amount that are in the database. It also wont allow me to select more then one name in the List Box.

[brow1726]

Like *2 of them amount that are in the database

Also when there is none it wont save any records

[ssanfu]

Show your code.

[brow1726]

Dont have to much code, Im in the learning process and just getting into the basics of it. What I have is an append query from "Query Design" in Access 2007. I can upload what I have granted I will only have a few name as compared to the 50 because of the senstive info.

[brow1726]

Here is a copy of it broken down

[brow1726]

Database112.accdb Sorry I had to get rid of a dlookup function this one works

[ssanfu]

I won't be able to look at it until tonight.

[pbaldy]

There's a lot wrong. Offhand, your listbox is not set to Multi Select, your query doesn't use it anyway (and couldn't), the query doesn't have joins, and your form is bound to the table.

Did you not see the code and sample db in the link above? You won't be able to use a multiselect listbox without code. Your checkbox idea would be awkward at best, and I believe would also require code.