RE: Cannot set value via event

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


"MikeJohnB" wrote:

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


"redFred" wrote:

Yes, thanks.

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

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



"MikeJohnB" wrote:

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


"redFred" wrote:

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
.

Quantcast