Cannot set value via event

[redFred]

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B

 

[redFred]

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[redFred]

Yes, I am aware of that.

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, I am aware of that.

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[redFred]

Still? I have gotten no suggestions as to what could be my issue.

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, I am aware of that.

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Still? I have gotten no suggestions as to what could be my issue.

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Still? I have gotten no suggestions as to what could be my issue.

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[redFred]

For a test you need three forms.

1. Stand alone with update control, bound, button to call #2.
2. Stand alone popup, bound.
3. Subform of #2, bound. A control's event (any, but I want BeforeUpdate)
contains the code referencing #1 form update control for "=Now()".

Did you specifically test this way?

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Still? I have gotten no suggestions as to what could be my issue.

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[redFred]

Did you see my reply of 10:06 AM PST?

Is the code you are calling it from in an event?
Is that event on a subform of the form you are calling it from?

See my most recent response prior to this.

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[redFred]

Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

Phewwww, been trying to replicate your problem, got all sorts of forms,
popup, bound, unbound subforms etc in the trial Database.

However, really glad you have got to the bottom of the issue. I can now
relax to my sick bed. Got one Bitch of a cold.

All the very best fred

Best wishes for the Holiday and Happy New Year

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred

 

[MikeJohnB]

Don't know what happened to my Reply,

Glad you got to the bottom of the issue now, Got all sorts of tables,
Queries, forms, subforms, popup forms on the trial database here but couldn't
find the problem.

Have a really good Holiday Fred and a happy 2009

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred