Search and Update the record that meets criteria (1 Viewer)

[comep]

I test it and its working fine but i raise two question mentioned above to help me

 

[isladogs]

Also i face an issue as there s a dialog box appeared to save changes manually after each time of closing the form so is there a solution for it

Is this question still relevant?
I assume not as the data was saved using the update query code
If its still an issue, then assuming you have a close button cmdClose, code like this should work

Private Sub cmdClose_Click()
 'this forces a save if not already done
   If Me.Dirty Then Me.Dirty=False

End Sub

Are these the other questions?

1. How can prevent users to move to next record using tab button ?
2. How can users move to next record which related to same user only with using another button ?

1. Do you mean tabbing to the next control?
If so, disable by changing the TabStop property to No for each form control

If you don't want users to move to the next record, go to Form Properties and change Navigation Buttons to 'No'

2. Sorry - don't understand

Logging off now for a few hours

 

[comep]

My questions are :-

- I want to prevent users to move to next record by pressing tab button .
- I want to prevent users to edit records not related to him .
- I want to the user to move to next record which belong to him only by using command button .

 

[isladogs]

My questions are :-

1. I want to prevent users to move to next record by pressing tab button .
2 I want to prevent users to edit records not related to him .
3 I want to the user to move to next record which belong to him only by using command button .

1. Already answered
2. Presumably you mean not written by that user
You could either filter the display so users only see their own records
OR add code Form.Locked = True to Form_Current event where record was written by someone else
3. Easiest if you filter so users only see their own records

No time to provide details on this now.
Perhaps someone will step back in to assist you
In the meantime, do a site search