Automating a process with a form

[Topper]

Hello everyone,


I'm really struggling with a form in a registration database I'm making for an event next week.




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 (see attached picture). 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 and hitting carriage return 'opens' the relevant record.


Here's what I want to happen - I want the registrar at reception to simply have to:


1. Enter the child ID number in to the ID box (every ID is three digits)
2. This automatically searches for the child (no need to click carriage return) and 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 really love someone to be able to help. I can provide Skype details if a vocal explanation would be more understandable!



Thanks,

Andrew

[pbaldy]

Hey, this person is working on a similar problem!

http://www.access-programmers.co.uk/...d.php?t=248286

[Topper]

Well isn't that strange!! I felt somewhat neglected by our friends over at access-programmers! And didn't want to hastle them anymore lol - perhaps you nice people can assist me??