Data Entry Form and undo changes

[Birky]

I’m hoping you can help me get my form to work. I have a few issues that I need to get squared away.

1. I am using a form for data entry only therefore I need the form to pop with the next available record. If I can get the form to load and be ready for input, making it as simple as possible for the user to enter records without having to navigate to the end of the database would be helpful.

2. I have an event_create_timestamp within a form in which I would like to auto populate when the form loads (same form as question number 1). Can I get the form to auto populate the field so the user does not have to? I currently have the field enactive so they can see it just not alter it.

3. Can you help me with a clear all fields in case they enter bogus data and want to start over before the record is saved to the database? It would be nice to clear all the data they may have entered and place them back into a scenario where they can carry on and append a record to the database.

Any help in getting these situations ironed out would be extremely appreciated..


Thanks much..
Mike

[MMcCarthy]

"The title of this thread has been changed to make the problem clearer to experts and others searching for similar threads."

MODERATOR

[MMcCarthy]

I’m hoping you can help me get my form to work. I have a few issues that I need to get squared away.

1. I am using a form for data entry only therefore I need the form to pop with the next available record. If I can get the form to load and be ready for input, making it as simple as possible for the user to enter records without having to navigate to the end of the database would be helpful.

In the form properties, under the data tab, set the Data Entry property to Yes.

2. I have an event_create_timestamp within a form in which I would like to auto populate when the form loads (same form as question number 1). Can I get the form to auto populate the field so the user does not have to? I currently have the field enactive so they can see it just not alter it.

In the field (controls) properties under the data tab, set the default value to Now()

3. Can you help me with a clear all fields in case they enter bogus data and want to start over before the record is saved to the database? It would be nice to clear all the data they may have entered and place them back into a scenario where they can carry on and append a record to the database.

You need to put the following line of code behind a command button on the form.

[PHP]
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
[/PHP]

Mary

[Birky]

Thanks Mary,

I will try to better describe my issues within the Title on future posts. Your assistance was truly appreciated and helped fill in multiple pieces of the puzzle. I am new to Access and am trying to learn from documentation (“Access 2003 Bible” from Wiley publications). I must admit it was truly above me but I am now starting to understand how this all works. I do have a few other questions though.

Can you recommend a reference that would give examples of how to build objects within a form or report? I unfortunately learn via example and need to see the context and structure of the statement before I can grasp it.

How can I pass the focus back to the first object within a form after the Clear command button is selected?

Again, I really appreciate the help. Thanks GOD for people like you who are willing to help goobers like me..

Mike

[MMcCarthy]

Thanks Mary,

I will try to better describe my issues within the Title on future posts. Your assistance was truly appreciated and helped fill in multiple pieces of the puzzle. I am new to Access and am trying to learn from documentation (“Access 2003 Bible” from Wiley publications). I must admit it was truly above me but I am now starting to understand how this all works. I do have a few other questions though.

You're welcome Mike.

Can you recommend a reference that would give examples of how to build objects within a form or report? I unfortunately learn via example and need to see the context and structure of the statement before I can grasp it.

Check out the thread called 'Links to useful Sites' near the top of the access forums.

How can I pass the focus back to the first object within a form after the Clear command button is selected?

just add the line ...

Me.ControlName.SetFocus 

after the undo statement

Mary