Option Buttons and Text Box Problem

[Merwin12]

AC 97, SQL 7 backend
I have two option groups and one bound text box.

1st Option Group:
Red, Blue, White

2nd Option Group:
Apple, Sky, Dove

Textbox should display depending on your selection from
above:
Red Apple

I have a computed column at the back end for the textbox
so it concatenates the value of the two option groups.

The problem I am encountering is that I get this error
message when I make a different selection/update:

"The data has been changed.
Another user edited this record and saved the changes
before you attempted to save your changes.
Re-edit the record."

I have Me.Recalc on the after update for each option group.

Please help.
Thanks.

 

[ScottE]

I'm not sure why you're getting that error. I suggest
setting the textbox value in the after_update events on
both optiongroups as equal to OptionG1.value & " " &
OptionG2.value, rather than using recalc.

Either that, or the problem is because the textbound is
bound. The more VB/Access I do, the fewer bound controls
I use. Althuogh you have to write code to save data from
an unbound form, the benefits of user control and error-
aviodance usually outweigh the hassle, IMHO.

Hope this helps!

- Scott

 

[Jonathan Parminter]

-----Original Message-----
AC 97, SQL 7 backend
I have two option groups and one bound text box.

1st Option Group:
Red, Blue, White

2nd Option Group:
Apple, Sky, Dove

Textbox should display depending on your selection from
above:
Red Apple

I have a computed column at the back end for the textbox
so it concatenates the value of the two option groups.

The problem I am encountering is that I get this error
message when I make a different selection/update:

"The data has been changed.
Another user edited this record and saved the changes
before you attempted to save your changes.
Re-edit the record."

I have Me.Recalc on the after update for each option group.

Please help.
Thanks.

.

Hi Merwin12,
this sounds like a record locking issue. You mentioned
that you have a split database, but does each user have
their own copy of the front end to work in? Also are you
limiting form record source to return as few records as
possible (preferably a single record)?

Luck
Jonathan