|
|
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
|
|
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:
[Quoted Text] > 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
|
|
Yes, thanks.
Forms![1frmclient].Form!txtLastUpdate = Now
Like I stated...in any event as the only code.
"MikeJohnB" wrote:
[Quoted Text] > 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
|
|
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:
[Quoted Text] > 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
|
|
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:
[Quoted Text] > 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
|
|
Yes, I am aware of that.
"MikeJohnB" wrote:
[Quoted Text] > 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
|
|
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
"redFred" wrote:
[Quoted Text] > Yes, I am aware of that.
>
> "MikeJohnB" wrote:
>
> > 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
|
|
Still? I have gotten no suggestions as to what could be my issue.
"MikeJohnB" wrote:
[Quoted Text] > 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
>
>
> "redFred" wrote:
>
> > Yes, I am aware of that.
> >
> > "MikeJohnB" wrote:
> >
> > > 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
|
|
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
"redFred" wrote:
[Quoted Text] > Still? I have gotten no suggestions as to what could be my issue.
>
>
>
>
> "MikeJohnB" wrote:
>
> > 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
> >
> >
> > "redFred" wrote:
> >
> > > Yes, I am aware of that.
> > >
> > > "MikeJohnB" wrote:
> > >
> > > > 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
|
|
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
"MikeJohnB" wrote:
[Quoted Text] > 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
>
>
> "redFred" wrote:
>
> > Still? I have gotten no suggestions as to what could be my issue.
> >
> >
> >
> >
> > "MikeJohnB" wrote:
> >
> > > 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
> > >
> > >
> > > "redFred" wrote:
> > >
> > > > Yes, I am aware of that.
> > > >
> > > > "MikeJohnB" wrote:
> > > >
> > > > > 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
|
|
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?
"MikeJohnB" wrote:
[Quoted Text] > 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
>
>
> "redFred" wrote:
>
> > Still? I have gotten no suggestions as to what could be my issue.
> >
> >
> >
> >
> > "MikeJohnB" wrote:
> >
> > > 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
> > >
> > >
> > > "redFred" wrote:
> > >
> > > > Yes, I am aware of that.
> > > >
> > > > "MikeJohnB" wrote:
> > > >
> > > > > 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
|
|
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.
"MikeJohnB" wrote:
[Quoted Text] > 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
>
>
> "MikeJohnB" wrote:
>
> > 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
> >
> >
> > "redFred" wrote:
> >
> > > Still? I have gotten no suggestions as to what could be my issue.
> > >
> > >
> > >
> > >
> > > "MikeJohnB" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > > "redFred" wrote:
> > > >
> > > > > Yes, I am aware of that.
> > > > >
> > > > > "MikeJohnB" wrote:
> > > > >
> > > > > > 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
|
|
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.
"MikeJohnB" wrote:
[Quoted Text] > 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
>
>
> "MikeJohnB" wrote:
>
> > 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
> >
> >
> > "redFred" wrote:
> >
> > > Still? I have gotten no suggestions as to what could be my issue.
> > >
> > >
> > >
> > >
> > > "MikeJohnB" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > > "redFred" wrote:
> > > >
> > > > > Yes, I am aware of that.
> > > > >
> > > > > "MikeJohnB" wrote:
> > > > >
> > > > > > 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
|
|
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
"redFred" wrote:
[Quoted Text] > 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.
>
>
> "MikeJohnB" wrote:
>
> > 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
> >
> >
> > "MikeJohnB" wrote:
> >
> > > 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
> > >
> > >
> > > "redFred" wrote:
> > >
> > > > Still? I have gotten no suggestions as to what could be my issue.
> > > >
> > > >
> > > >
> > > >
> > > > "MikeJohnB" wrote:
> > > >
> > > > > 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
> > > > >
> > > > >
> > > > > "redFred" wrote:
> > > > >
> > > > > > Yes, I am aware of that.
> > > > > >
> > > > > > "MikeJohnB" wrote:
> > > > > >
> > > > > > > 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
|
|
|