Wondering how to design a event code to do two tasks: refresh page and add status to column in table

[chloe]

Good morning!

I am a pretty new access user and, while I am computer savvy, I'm running into some issues with coding. I have a button on my form that I have setup so that when the person entering information it "saves it" and clears the form. Really its really just a refresh code so that the form appears blank and ready for the next entry (shown below). What I'm wondering is:

1) Can I program this event code to do TWO things - refresh the page, and then update the status of the form to a column in the table?
Example: When I click this button, it will add the word "Pending" to the Status column of my table and refresh/save the form as new. I want it to do both things. My goal is to have a couple different buttons on my form that will generate different statuses, depending on the stage of production (Pending, In Progress, Verified, Complete).

Right now, my event procedure code is: DoCmd.GoToRecord acDataForm, "DatabaseA", acNewRec



What do I need to do to have it do both of those features. Can I even code one button to do two things or is that asking too much of access?

Also, part 2 of this question, If this button thing can work, is there a way so that I can create a "status box" on the form that reflects what the column currently says? My thought process is, if a record comes up and shows its "in progress" the user will know someone is working on it vs. "pending" where it means something needs to be done, verified meaning it has to undergo review by a supervisor, and complete meaning everything is done. It sounds more complicated than it is.

If anyone has any other suggestions, I'm open for ideas, but this would be the ideal way for this form to function.

Thanks a bunch!

[orange]

Have you looked at setting the form's Data Entry property to True/Yes?
Not sure exactly where your Status would go...

[June7]

Don't really understand issue. If status is a value saved with record, can have textbox bound to field for display.

Yes, each status button can have code that populates the status field and saves record.

[chloe]

The issue is I want to click a button that says "save and refresh" that will both refresh the page for a new entry and place the "status" column in the linked data table to entered. I want another button the form to say "save and answer" that will both refresh the page for a new entry and change the status column in the table to say "in progress". I don't know how to do this. Code examples would be great. I do not want a text box or a list box, I want to just click the button and have it do those two things.

[orange]

I think you are in for some custom vba coding. When you save a record you can update tables with the data you want.
I think you are confusing WHAT you want to happen, with HOW you think it should be done.

Anyway, good luck with your project.

[June7]

Are you saying the field you want to edit is not part of the form RecordSource? Where is 'status column'?

"Refresh the page for a new entry" by moving to new record row. That will also save the current record.

[Missinglinq]

First off, moving to a New Record has nothing to so with refreshing a form; that's something else, entirely, and you're confusing the issue by using it, here!

Secondly, as June7 said, the act of moving to a New Record will save the Current Record and make the Form ready for a New Record, with all Controls empty.

Assuming that the Status Field is part of the RecordSource for the Form, simply place a Control on the Form with its Control Source set to that Field.

Rather than having four 'save and whatever' buttons, I'd have one button for moving to a New Record (using your above code) which will save the Record and use a Combobox as the Control for the selection of the Status Field. It's not hard to do:

1. Place a Combobox on the Form
2. Select "I will type the Values I want"
3. Under Col1 enter Pending, In Progress, Verified and Complete
4. Step through the rest of the Combobox Wizard
5. With the Combobox selected, go to Properties - Data and set the Control Source to the Status Field.

If you want, you can make the Status Field required by using code in the Form_BeforeUpdate event to check that a status has been selected, and cancel the update until it is.

Linq ;0)>