Access Forms

[duddu]

Hi, I'm new to Ms Access.


I need some help to do this task::
I have 5000 records and when I open forms by ascending order and updated something in the form and click the save button that form need to be closed form doesn't appear for the next person.. and next form will be open for ready to fill..

Appreciated for your help!!


Sent from my iPhone using Tapatalk

[RuralGuy]

There is no reason for a save button. Unless you take extraordinary steps, Access always saves changes to a record when you move to a new record or close the form.

[davegri]

Instead of a 'Save' button, you need a 'Next' button.

Private Sub cmdNext_Click()
    On Error Resume Next
    DoCmd.GoToRecord , "", acNext
End Sub

[duddu]

Once update something in the form and saving the table I want to not show up again for the next person. Once it is saved like its a closed record.


Sent from my iPhone using Tapatalk

[pbaldy]

I merged your threads since they ask the same question. You'll need a field that flags the record as having been dealt with. It could be a date/time, yes/no, or whatever. Set this field in the before update event of the form and base the form on a query that excludes records that have been dealt with.

[duddu]

I merged your threads since they ask the same question. You'll need a field that flags the record as having been dealt with. It could be a date/time, yes/no, or whatever. Set this field in the before update event of the form and base the form on a query that excludes records that have been dealt with.

I really have no idea. Could you please tell me step by step How to create a flag in field? And query.!



Sent from my iPhone using Tapatalk

[Homegrownandy]

He did give some examples, But a good one could be to create a field to mark "completion_date" or whatever you want. Then when you chose to save that record it could trigger an update query to add a date for when you completed.

Then all you do is load your list form excluding records with a completed date.