Not allowing next record

[genxiii]

hey guys, i have a problem here i can't figure.

I have a form where the user will be making a record entry for the first time ever. once the entry is made they have to exit the form. i don't want them to access any other record including a new empty one. I've taken out all the controls to do that but they are still able to move to an empty new record by using the mouse scroller. how do i prevent that from happening? any help would be great. thanks

 

[Rolliee]

Make a new form by doing an Edit/ Copy of the old form. Name the new form the same name except add "Nu" on the front of it.

Move from control properties of each control and delete "control" thus divorcing the control from it's former field.

Change the name of each control to the same as it was except an 'txt' in front of the name.

Open the 'Nu' form and let the user fill iin the data. Add it to the recordset woth VB code (my preference) or an SQL INSERT when the user presses a "SAVE" button.


Rollie E

If any of these tips are worthy of stars, please click the "This tip is useful button..."

 

[genxiii]

i could do that but i have a lot of subforms that i also need to add to the record at the same time and it makes things a whole lot more complicated

 

[Rolliee]

Life is complicated. This process can be done rather rapidly.

Rollie E

 

[jfgambit]

In the Properties View of the form select the All tab, change the Cycle Property to Current Record.



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"