Restricting the adding of records into table from form

[kyuball]

Please excuse me if this has already been covered in this forum before, but I could not find an answer for my problem despite poring through the threads. Also, please excuse me if this is something stupidly simple as I am an almost complete beginner and self-taught (can't seem to teach myself much though....)

I work for a social work organization and am building a simple database to track fees and co-payments for our day program (mind you, this was all being recorded on a spiral bound notebook even as far back as last week!) I have two forms that, respectively, add client profile and payments into separate tables. I have them set not to allow additions (I also use the form to edit client information) but have a switch board with buttons that open the forms in add mode.

How can I get those forms to 1) Not automatically enter a new record into their respective tables without some sort of confirmation/ prompt in case someone decides not to enter the info at the time? 2) How can I get the form not to automatically go to a new blank record when tabbing out of the last field but instead just go back to the first field? In fact, when a person presses enter, I would like the prompt or confirmation message for saving record to go into effect.

 

[Galaxiom]

1) Until you move to another record you can cancel the new record creation. Just hit escape until the control values are all cleared. Otherwise use the button wizard to make an Undo Record button on the form.

However if you move to another record the new record will be saved. Then you will have to delete it.

2) To automatically go to the first record when reaching the end of the table you will have to use code.

Please also read this post about how to ask questions.

http://www.access-programmers.co.uk/forums/showthread.php?t=170250