Problem with Editing data and ControlSource

[saddist]

Hello,
Description:
1. I have a columnar form
2. There are 2 fields on this form: ID and NAME
3. Both fields have ControlSource ID_EMP and NAME_EMP
4. Both fields have enabled = false
5. I also have 2 buttons EDIT and ACCEPT

Problem:
I would like to edit NAME_EMP in selected record. After I click Edit I set all fields enabled = true. Now I want to edit NAME_EMP but save record only after I click ACCEPT. Now the record saves itself right after entering new value. How can I do that?

Cheers

[missinglinq]

Not sure exactly what you mean by

saddist
Now the record saves itself right after entering new value

By default Access saves a record when you move to another record or close a form, provided required fields have been filled and all data validation is correct . Is this the behavior you're referring to in your statement, or is it truly saving the record after simply editing the name?

Linq ;0)>

[saddist]

when I enter new value in NAME textfield, and then change focus, the record changes. I want it to change only after I click ACCEPT button

Cheers

Not sure exactly what you mean by
By default Access saves a record when you move to another record or close a form, provided required fields have been filled and all data validation is correct . Is this the behavior you're referring to in your statement, or is it truly saving the record after simply editing the name?

Linq ;0)>

[MikeTheBike]

Hi

when I enter new value in NAME textfield, and then change focus, the record changes.

If the NAME textbox is the last control in the Tab Order, then when youn tab out of it it moves to the next record if the Cycle property is set to 'All Records' (which is the default). Is that the case?

If so, then change the property (Form -> Properties -> Other tab) to 'Current Record'

??


MTB

[missinglinq]

From what you said in #3 Mike's suggestion should solve the problem!

Linq ;0)>

[saddist]

it's not the case. I will try to show you the whole form:

Select emp: [combobox]
NAME: [textbox, ControlSource NAME_EMP]
CITY: [textbox, ControlSource: CITI_EMP]
SALARY: [textbox, ControlSource SALARY_EMP]
[buttonEdit]
[buttonAccept]
[buttonUndo]
[buttonCancel]

When I change something in NAME and then switch do CITI the record still updates. I want it to update only after I call buttonAccept_Click() method.

And now I have other problem. I made button called Undo. Here's the code:

Private Sub btnUndo_Click()
Dim ctlC As Control

For Each ctlC In Me.Controls
If ctlC.ControlType = acTextBox Then
ctlC.Value = ctlC.OldValue
End If
Next ctlC

End Sub

The problem is that it works fine for CITY textbox, but return error for NAME and SALARY. Error:
"Operation is not supported for this type of object"

Hi



If the NAME textbox is the last control in the Tab Order, then when youn tab out of it it moves to the next record if the Cycle property is set to 'All Records' (which is the default). Is that the case?

If so, then change the property (Form -> Properties -> Other tab) to 'Current Record'

??


MTB

[MikeTheBike]

Hi

For the undo I would try this

Private Sub btnUndo_Click()
 
      If Me.Dirty Then Me.Undo
 
End Sub

Other that my previous post, I cannot think of a reason why a record updates when you move from one control to the next. Perhaps there is some other code we do no know about!

The problem is that it works fine for CITY textbox, but return error for NAME and SALARY. Error:
"Operation is not supported for this type of object"

I'm not sure what works fine with the CITY textbox or what operation is not supported!?


MTB

[saddist]

Hi

For the undo I would try this

Private Sub btnUndo_Click()
 
      If Me.Dirty Then Me.Undo
 
End Sub

MTB

Still doesn't work :/ same error occures

I'm not sure what works fine with the CITY textbox or what operation is not supported!?
MTB

The undo function you wrote works fine for CITY textbox, but returns error for others.

[missinglinq]

when I enter new value in NAME textfield, and then change focus, the record changes. I want it to change only after I click ACCEPT button

Question: How do you know the record changes after moving focus to another control within the same record? What are you basing this observation/statement on?

The same question vis a vis the undo code throwing errors for NAME and SALARY. How are you determining that these two controls are throwing errors with this code?

Linq ;0)>

[MikeTheBike]

Hi

I'm with missinglinq.
We are missing something here (well obviously!)

Could you post all the code for the sub that throw the error and indicate which line causes the problem?

It just might give us a clue.

MTB