Open a new Record when opening a from

[klon2001cr]

When I open the "TASK" form I need the form to take me to add a new record....

And once i have the new record, i dont wnt the user to be eble to seletec other record, just the new record (like a filter)

can you pls help me?

 

[pbaldy]

Look at the DataMode argument of OpenForm in VBA help.

 

[Lazy Days]

Create a macro. Set the Action to "GoToRecord, Object "Form", ObjectName "the name of your form" and Record "New". Then open the form in design view and go to the properties, on On Open, select the down arrow and then select the macro you just created. When the form is opened, it will be at a new record.

 

[Lazy Days]

To set it where they can't see previous records, open the form in design view again and go to the properties. Set Navigation Buttons to No

 

[klon2001cr]

To set it where they can't see previous records, open the form in design view again and go to the properties. Set Navigation Buttons to No

TKS man, but I already did that. What i mean is even if the navigation buttons are off the user can press the TAB key or move the mouse wheel. is there other way to do it? TKS

 

[pbaldy]

Post #2 is a better method anyway.

 

[klon2001cr]

Create a macro. Set the Action to "GoToRecord, Object "Form", ObjectName "the name of your form" and Record "New". Then open the form in design view and go to the properties, on On Open, select the down arrow and then select the macro you just created. When the form is opened, it will be at a new record.

This is excelent. TKS!!!

 

[pbaldy]

My cloak of invisibility is working perfectly!

 

[klon2001cr]

My cloak of invisibility is working perfectly!

Sorry, I already try your option.

TKS

 

[pbaldy]

I believe it is the more efficient option. Opening the form in data entry mode will not load existing records. The other method will load existing records, whether they are accessible to the user or not. The more records in the table, the less efficient that method will be.