Please help with this form!
Posted on 2013-06-13
I'm really struggling with a form in a registration database I'm making for an event next week. I've tried a couple of other forums but to no avail - hopefully this site will prove to be the one that helps!!
I have one table, called details, which has the follow fields: ID, ChildName, Age, ParentPhone, Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday (those last few fields are to record daily attendance).
So, all the first fields are filled in before the event starts… on a daily basis, all that needs filled out is the check box for the relevant day (saturday, sunday etc).
I've made a simple form for each day. It has three of the fields on it - 'ID' , 'ChildName' and 'Saturday' (or whatever the day is). The 'ID' field is a combo box - entering the child ID (which is done using a usb barcode scanner - simply enters a number) 'opens' the relevant record.
Here's what I want to happen - I want the registrar at reception to simply have to:
1. Scan the ID barcode
2. Once the record is opened it then...
3. .. ticks the 'saturday' box (labelled 'present') for that day
4. saves the record
5. returns the cursor to the ID box (labelled Search) ready for the next child..
I trust this makes sense. I've been really struggling to do this - I'd really love someone to be able to help. I can provide Skype details if a vocal explanation would be more understandable!