open house db update

Well I am getting close but not happy. I have created a db where the user will enter who has come to our open house. I created a form for customers that we currently have and another form for new customers. The current customer form, [frm_current_register] is fine. It works how I want it to. However the new register form, [frm_register_new], does not.

I'm expecting the user to first see if they have already registered. The user would search the search combo box to find the company, select it, and go on. If they don't find them then they will go to the new customer record in the combo box and create a new record. This is where it gets messy.

They select New Customer in combo box then go to the subform and select the button for a new record. 1ST ISSUE: soon as they put data in it errors. They can click ok and proceed but it still errors. 2ND ISSUE: they go ahead and put the new record info in and tab past the last record. It goes into a new record in that subform. I would like the tab order to stop at the last record and go to the next subform. 3RD ISSUE: Can I specify that when the user hits the enter key it advances to a different subform and the tab key advances to fields in that subform.

Well I found an solution to Issue2 thru some feedback by Big Jon Booty

If you simply want to restrict the user to the current record, then set the Cycle property to Current Record

Click to expand...

He had another solution to that I didn't use. you can find the thread here http://www.access-programmers.co.uk/forums/showthread.php?t=210006

This also inadvertenly fixed Issue #1. No more error.