Wierd error message on form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has Me.AllowEdits = False in the On Open event. The form
has two controls on it that are giving me the trouble. fldHeightInches and
fldWeightPounds. These two fields are also used in the query that populates
the form (frmClinicalPresentation) to calculate total body surface area
(BSA). When the from opens, other controls cannot be edited until the edit
button is clicked. These two however, allow data to be entered without the
form being in edit mode. Id get a pop-up error msg that states "Field Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently locked
by another user. Wait for the other user to finish working with the record or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field and my
form is now editable even though the Edit button was never clicked. After
there is an entry in these fields, if I come back to the form after closing,
everything works fine.

I've checked everything, all the properties and no locks are set on these
fields.

Is it possible the calculated field is having some effect on this? Here's
the query.

SELECT tblClinicalPresentation.fldCPNo, tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds, tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation, tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is Null) Or
([fldWeightPounds] Is Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
 
If you dirty the form programmatically, Access allows you to continue with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or GotFocus of
one of the controls bound to a problem field, or the Exit of LostFocus of
one of the other controls, or the Current or AfterUpdate events of the form,
or ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
I have a form that has Me.AllowEdits = False in the On Open event. The form
has two controls on it that are giving me the trouble. fldHeightInches and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface area
(BSA). When the from opens, other controls cannot be edited until the edit
button is clicked. These two however, allow data to be entered without the
form being in edit mode. Id get a pop-up error msg that states "Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently locked
by another user. Wait for the other user to finish working with the record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field and my
form is now editable even though the Edit button was never clicked. After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on these
fields.

Is it possible the calculated field is having some effect on this? Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
 
Hi Allen, thanks for your post back. The problem existed before I put the
dirty method in the query. No macros, no other wierd things. It's only
happens on the fields that are used to provide numbers for the calculated BSA
field. Could this be contributing to the problem?

Thanks, Robert

Allen Browne said:
If you dirty the form programmatically, Access allows you to continue with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or GotFocus of
one of the controls bound to a problem field, or the Exit of LostFocus of
one of the other controls, or the Current or AfterUpdate events of the form,
or ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
I have a form that has Me.AllowEdits = False in the On Open event. The form
has two controls on it that are giving me the trouble. fldHeightInches and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface area
(BSA). When the from opens, other controls cannot be edited until the edit
button is clicked. These two however, allow data to be entered without the
form being in edit mode. Id get a pop-up error msg that states "Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently locked
by another user. Wait for the other user to finish working with the record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field and my
form is now editable even though the Edit button was never clicked. After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on these
fields.

Is it possible the calculated field is having some effect on this? Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
 
Sorry, I didn't understand that.

I'm not clear how you put the Dirty method in a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
Hi Allen, thanks for your post back. The problem existed before I put the
dirty method in the query. No macros, no other wierd things. It's only
happens on the fields that are used to provide numbers for the calculated
BSA
field. Could this be contributing to the problem?

Thanks, Robert

Allen Browne said:
If you dirty the form programmatically, Access allows you to continue
with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or GotFocus
of
one of the controls bound to a problem field, or the Exit of LostFocus of
one of the other controls, or the Current or AfterUpdate events of the
form,
or ...

RobUCSD said:
I have a form that has Me.AllowEdits = False in the On Open event. The
form
has two controls on it that are giving me the trouble. fldHeightInches
and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface area
(BSA). When the from opens, other controls cannot be edited until the
edit
button is clicked. These two however, allow data to be entered without
the
form being in edit mode. Id get a pop-up error msg that states "Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently
locked
by another user. Wait for the other user to finish working with the
record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field and
my
form is now editable even though the Edit button was never clicked.
After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on
these
fields.

Is it possible the calculated field is having some effect on this?
Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is
Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
Click to expand...
 
Sorry Allen, I got confused with something else I was doing. There is no
Dirty method in the query or any of the form's code.

Could the problem be with the fields used to calc BSA?

Thanks, Rob

Allen Browne said:
Sorry, I didn't understand that.

I'm not clear how you put the Dirty method in a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
Hi Allen, thanks for your post back. The problem existed before I put the
dirty method in the query. No macros, no other wierd things. It's only
happens on the fields that are used to provide numbers for the calculated
BSA
field. Could this be contributing to the problem?

Thanks, Robert

Allen Browne said:
If you dirty the form programmatically, Access allows you to continue
with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or GotFocus
of
one of the controls bound to a problem field, or the Exit of LostFocus of
one of the other controls, or the Current or AfterUpdate events of the
form,
or ...

I have a form that has Me.AllowEdits = False in the On Open event. The
form
has two controls on it that are giving me the trouble. fldHeightInches
and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface area
(BSA). When the from opens, other controls cannot be edited until the
edit
button is clicked. These two however, allow data to be entered without
the
form being in edit mode. Id get a pop-up error msg that states "Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently
locked
by another user. Wait for the other user to finish working with the
record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field and
my
form is now editable even though the Edit button was never clicked.
After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on
these
fields.

Is it possible the calculated field is having some effect on this?
Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is
Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
Click to expand...
 
It won't cause the problem to have text boxes bound to an expression, i.e.
the Control Source starts with =.

But if the text boxes are bound to a field in the table, and you assign them
a value, that will cause the behavior you describe.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
Sorry Allen, I got confused with something else I was doing. There is no
Dirty method in the query or any of the form's code.

Could the problem be with the fields used to calc BSA?

Thanks, Rob

Allen Browne said:
Sorry, I didn't understand that.

I'm not clear how you put the Dirty method in a query.

RobUCSD said:
Hi Allen, thanks for your post back. The problem existed before I put
the
dirty method in the query. No macros, no other wierd things. It's only
happens on the fields that are used to provide numbers for the
calculated
BSA
field. Could this be contributing to the problem?

Thanks, Robert

:

If you dirty the form programmatically, Access allows you to continue
with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or
GotFocus
of
one of the controls bound to a problem field, or the Exit of LostFocus
of
one of the other controls, or the Current or AfterUpdate events of the
form,
or ...

I have a form that has Me.AllowEdits = False in the On Open event.
The
form
has two controls on it that are giving me the trouble.
fldHeightInches
and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface
area
(BSA). When the from opens, other controls cannot be edited until
the
edit
button is clicked. These two however, allow data to be entered
without
the
form being in edit mode. Id get a pop-up error msg that states
"Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently
locked
by another user. Wait for the other user to finish working with the
record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field
and
my
form is now editable even though the Edit button was never clicked.
After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on
these
fields.

Is it possible the calculated field is having some effect on this?
Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is
Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
Click to expand...
 
Hello Allen, Thanks for this. I don't really understand what you mean though.
The source for the form is from the query that you can see at the begining of
this thread. Could you give me a little more detail on what you mean by
"...text boxes bound to an expreesion... control source starts with =."

Thanks for your help Allen and I'm apologize for my ingnorance. Rob

Allen Browne said:
It won't cause the problem to have text boxes bound to an expression, i.e.
the Control Source starts with =.

But if the text boxes are bound to a field in the table, and you assign them
a value, that will cause the behavior you describe.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
Sorry Allen, I got confused with something else I was doing. There is no
Dirty method in the query or any of the form's code.

Could the problem be with the fields used to calc BSA?

Thanks, Rob

Allen Browne said:
Sorry, I didn't understand that.

I'm not clear how you put the Dirty method in a query.

Hi Allen, thanks for your post back. The problem existed before I put
the
dirty method in the query. No macros, no other wierd things. It's only
happens on the fields that are used to provide numbers for the
calculated
BSA
field. Could this be contributing to the problem?

Thanks, Robert

:

If you dirty the form programmatically, Access allows you to continue
with
the editing until the record is saved or discarded, even if the form's
AllowEdits is No. That kinda makes sense, so you are not stuck with a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or
GotFocus
of
one of the controls bound to a problem field, or the Exit of LostFocus
of
one of the other controls, or the Current or AfterUpdate events of the
form,
or ...

I have a form that has Me.AllowEdits = False in the On Open event.
The
form
has two controls on it that are giving me the trouble.
fldHeightInches
and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body surface
area
(BSA). When the from opens, other controls cannot be edited until
the
edit
button is clicked. These two however, allow data to be entered
without
the
form being in edit mode. Id get a pop-up error msg that states
"Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is currently
locked
by another user. Wait for the other user to finish working with the
record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the field
and
my
form is now editable even though the Edit button was never clicked.
After
there is an entry in these fields, if I come back to the form after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set on
these
fields.

Is it possible the calculated field is having some effect on this?
Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue, tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches] Is
Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
Click to expand...
 
Open the form in design view.
Right-click the text box in question, and choose Properties.
On the Data tab of the Properties box, what is beside the Control Source
property?

If it is an expression, it starts with =, such as:
=[Credit] - [Debit]
or:
=Sum([Amount]
or:
=[FirstName] & " " & [Surname]
Those expressions will not cause a problem.
(Any attempt to assign a value will fail.)

But if you have a field name in the Control Source, such as:
Credit
or
Surname
then it will cause the problem you see if you assign it a value in your
code.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RobUCSD said:
Hello Allen, Thanks for this. I don't really understand what you mean
though.
The source for the form is from the query that you can see at the begining
of
this thread. Could you give me a little more detail on what you mean by
"...text boxes bound to an expreesion... control source starts with =."

Thanks for your help Allen and I'm apologize for my ingnorance. Rob

Allen Browne said:
It won't cause the problem to have text boxes bound to an expression,
i.e.
the Control Source starts with =.

But if the text boxes are bound to a field in the table, and you assign
them
a value, that will cause the behavior you describe.

RobUCSD said:
Sorry Allen, I got confused with something else I was doing. There is
no
Dirty method in the query or any of the form's code.

Could the problem be with the fields used to calc BSA?

Thanks, Rob

:

Sorry, I didn't understand that.

I'm not clear how you put the Dirty method in a query.

Hi Allen, thanks for your post back. The problem existed before I
put
the
dirty method in the query. No macros, no other wierd things. It's
only
happens on the fields that are used to provide numbers for the
calculated
BSA
field. Could this be contributing to the problem?

Thanks, Robert

:

If you dirty the form programmatically, Access allows you to
continue
with
the editing until the record is saved or discarded, even if the
form's
AllowEdits is No. That kinda makes sense, so you are not stuck with
a
partial edit.

It therefore appears that you have something (code? macro?) that is
assigning a value to a bound control. It may be in the Enter or
GotFocus
of
one of the controls bound to a problem field, or the Exit of
LostFocus
of
one of the other controls, or the Current or AfterUpdate events of
the
form,
or ...

I have a form that has Me.AllowEdits = False in the On Open event.
The
form
has two controls on it that are giving me the trouble.
fldHeightInches
and
fldWeightPounds. These two fields are also used in the query that
populates
the form (frmClinicalPresentation) to calculate total body
surface
area
(BSA). When the from opens, other controls cannot be edited until
the
edit
button is clicked. These two however, allow data to be entered
without
the
form being in edit mode. Id get a pop-up error msg that states
"Field
Cannot
be Updated". the help button on the pop-up states:

"You tried to update a field in a record or table that is
currently
locked
by another user. Wait for the other user to finish working with
the
record
or
table, and then try the operation again."

If I press OK on the msg the value is then accepted into the
field
and
my
form is now editable even though the Edit button was never
clicked.
After
there is an entry in these fields, if I come back to the form
after
closing,
everything works fine.

I've checked everything, all the properties and no locks are set
on
these
fields.

Is it possible the calculated field is having some effect on
this?
Here's
the query.

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
tblClinicalPresentation.fldRhythm,
tblClinicalPresentation.fldRhythmFrequency,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfRhythm,
tblClinicalPresentation.fldNoYearsOfRhythm,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldPalpitation,
tblClinicalPresentation.fldChestPain,
tblClinicalPresentation.fldFatigue,
tblClinicalPresentation.fldSOB,
tblClinicalPresentation.fldDizziness,
tblClinicalPresentation.fldLackOfEnergy, (IIf(([fldHeightInches]
Is
Null)
Or
([fldWeightPounds] Is
Null),0,Sqr([fldHeightInches]*[fldWeightPounds]/3131)))
AS BSA
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldVisitNo)=[Forms]![frmPtDemographicNew]![frmVisitNewEdit].[Form]![VisitNo]));

As always, you're help is greatly appreciated. Thanks, Rob
Click to expand...
Click to expand...
Click to expand...
 
Back
Top