Control Source DRIVING ME MAD

[Craig]

Hi I have a text box on a form and when trying to change the control source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything it keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Allen Browne]

The square brackets around the names are optional, but Access will add them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood your
expression correctly. (If it puts quotes around something, it indicates
Access has misunderstood it as a literal instead of an object.)

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

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

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Craig]

But it is showing an #Error when displaying the info. I have used this in
other areas and it work but in this case it show an #Error. Can we turn this
function off and make our changes.
--
Thanks

Craig

The square brackets around the names are optional, but Access will add them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood your
expression correctly. (If it puts quotes around something, it indicates
Access has misunderstood it as a literal instead of an object.)

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

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

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Allen Browne]

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue lies.

BTW, is tsdsell a control in the subform, or just a field in the subform's
RecordSource. If there is not a *control* by that name, Access 2002 and 2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform. When
this happens and there are no records to display in the subform, the entire
detail section of the subform goes completely blank. Attempting to refer to
the controls that do not exist in the subform then generates an error.

HTH

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

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

But it is showing an #Error when displaying the info. I have used this in
other areas and it work but in this case it show an #Error. Can we turn
this
function off and make our changes.
--
Thanks

Craig

The square brackets around the names are optional, but Access will add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood your
expression correctly. (If it puts quotes around something, it indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Craig]

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue lies.

BTW, is tsdsell a control in the subform, or just a field in the subform's
RecordSource. If there is not a *control* by that name, Access 2002 and 2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform. When
this happens and there are no records to display in the subform, the entire
detail section of the subform goes completely blank. Attempting to refer to
the controls that do not exist in the subform then generates an error.

HTH

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

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

But it is showing an #Error when displaying the info. I have used this in
other areas and it work but in this case it show an #Error. Can we turn
this
function off and make our changes.
--
Thanks

Craig

The square brackets around the names are optional, but Access will add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood your
expression correctly. (If it puts quotes around something, it indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Allen Browne]

Okay, so both halves work alone, but the combination does not?

That suggests Access does not perceive them as the same data type, and
therefore cannot add them.

I understand tqdsell and Tqdgst to be text boxes in your subform.
Are they bound to fields in a table?
If so, what data types are the 2 fields?

Are they bound to calculated fields in a query, or to an expression?
If so, try typecasting the calculation in the query or in the ControlSource,
as described here:
http://allenbrowne.com/ser-45.html
You could also help Access understand the intended data type by setting the
Format property of the text boxes to Currency or General Number or some
such.

You could also try:
=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))


A further way to get Access to tell you how it understands these fields
would be to open the Immediate window, and enter:
? TypeName(Forms![YourMainFormNameHere].quotedetails.Form!tqdsell)

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

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

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate
data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name
of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue
lies.

BTW, is tsdsell a control in the subform, or just a field in the
subform's
RecordSource. If there is not a *control* by that name, Access 2002 and
2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform.
When
this happens and there are no records to display in the subform, the
entire
detail section of the subform goes completely blank. Attempting to refer
to
the controls that do not exist in the subform then generates an error.

HTH

But it is showing an #Error when displaying the info. I have used this
in
other areas and it work but in this case it show an #Error. Can we turn
this
function off and make our changes.
--
Thanks

Craig


:

The square brackets around the names are optional, but Access will add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood
your
expression correctly. (If it puts quotes around something, it
indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything
it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Ken Snell [MVP]]

PMFJI.... I just experienced a very similar problem in one of my database
applications where ACCESS would not properly calculate an expression (in
that case, I wanted to use an IIf function to decide which of two data
fields' values to display in the textbox). If I used a single field, all was
well. If I used the IIf function, I got an #Error -- casting with various
functions (CCur, CSng, etc.) made no difference. I tried rebuilding the
control. I even tried using the control names instead of field names; no
good.

I finally had to abandon the idea. There was no obvious reason why ACCESS
could not resolve the value -- both fields in the IIf arguments (true /
false arguments) were of the same data type as well.

--

Ken Snell
<MS ACCESS MVP>

Okay, so both halves work alone, but the combination does not?

That suggests Access does not perceive them as the same data type, and
therefore cannot add them.

I understand tqdsell and Tqdgst to be text boxes in your subform.
Are they bound to fields in a table?
If so, what data types are the 2 fields?

Are they bound to calculated fields in a query, or to an expression?
If so, try typecasting the calculation in the query or in the
ControlSource, as described here:
http://allenbrowne.com/ser-45.html
You could also help Access understand the intended data type by setting
the Format property of the text boxes to Currency or General Number or
some such.

You could also try:
=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))


A further way to get Access to tell you how it understands these fields
would be to open the Immediate window, and enter:
? TypeName(Forms![YourMainFormNameHere].quotedetails.Form!tqdsell)

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

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

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate
data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name
of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue
lies.

BTW, is tsdsell a control in the subform, or just a field in the
subform's
RecordSource. If there is not a *control* by that name, Access 2002 and
2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform.
When
this happens and there are no records to display in the subform, the
entire
detail section of the subform goes completely blank. Attempting to refer
to
the controls that do not exist in the subform then generates an error.

HTH

But it is showing an #Error when displaying the info. I have used this
in
other areas and it work but in this case it show an #Error. Can we
turn
this
function off and make our changes.
--
Thanks

Craig


:

The square brackets around the names are optional, but Access will
add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood
your
expression correctly. (If it puts quotes around something, it
indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the
control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything
it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Allen Browne]

If you do track down the cause, Ken, please let us know.

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

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

PMFJI.... I just experienced a very similar problem in one of my database
applications where ACCESS would not properly calculate an expression (in
that case, I wanted to use an IIf function to decide which of two data
fields' values to display in the textbox). If I used a single field, all
was well. If I used the IIf function, I got an #Error -- casting with
various functions (CCur, CSng, etc.) made no difference. I tried
rebuilding the control. I even tried using the control names instead of
field names; no good.

I finally had to abandon the idea. There was no obvious reason why ACCESS
could not resolve the value -- both fields in the IIf arguments (true /
false arguments) were of the same data type as well.

--

Ken Snell
<MS ACCESS MVP>

Okay, so both halves work alone, but the combination does not?

That suggests Access does not perceive them as the same data type, and
therefore cannot add them.

I understand tqdsell and Tqdgst to be text boxes in your subform.
Are they bound to fields in a table?
If so, what data types are the 2 fields?

Are they bound to calculated fields in a query, or to an expression?
If so, try typecasting the calculation in the query or in the
ControlSource, as described here:
http://allenbrowne.com/ser-45.html
You could also help Access understand the intended data type by setting
the Format property of the text boxes to Currency or General Number or
some such.

You could also try:
=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))


A further way to get Access to tell you how it understands these fields
would be to open the Immediate window, and enter:
? TypeName(Forms![YourMainFormNameHere].quotedetails.Form!tqdsell)

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

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

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig


:

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate
data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name
of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue
lies.

BTW, is tsdsell a control in the subform, or just a field in the
subform's
RecordSource. If there is not a *control* by that name, Access 2002 and
2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform.
When
this happens and there are no records to display in the subform, the
entire
detail section of the subform goes completely blank. Attempting to
refer to
the controls that do not exist in the subform then generates an error.

HTH

But it is showing an #Error when displaying the info. I have used
this in
other areas and it work but in this case it show an #Error. Can we
turn
this
function off and make our changes.
--
Thanks

Craig


:

The square brackets around the names are optional, but Access will
add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood
your
expression correctly. (If it puts quotes around something, it
indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the
control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything
it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Craig]

Hi Allan, I tried your control

=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))

and YES!!!!!!! it worked.

Thank you so much for your help.

PS: Can you explain why this worked (only if you have time).

Once again THANK YOU.

--
Thanks

Craig

Okay, so both halves work alone, but the combination does not?

That suggests Access does not perceive them as the same data type, and
therefore cannot add them.

I understand tqdsell and Tqdgst to be text boxes in your subform.
Are they bound to fields in a table?
If so, what data types are the 2 fields?

Are they bound to calculated fields in a query, or to an expression?
If so, try typecasting the calculation in the query or in the ControlSource,
as described here:
http://allenbrowne.com/ser-45.html
You could also help Access understand the intended data type by setting the
Format property of the text boxes to Currency or General Number or some
such.

You could also try:
=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))


A further way to get Access to tell you how it understands these fields
would be to open the Immediate window, and enter:
? TypeName(Forms![YourMainFormNameHere].quotedetails.Form!tqdsell)

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

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

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate
data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the subform
control? Its Name can be different from its SourceObject (i.e. the name
of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue
lies.

BTW, is tsdsell a control in the subform, or just a field in the
subform's
RecordSource. If there is not a *control* by that name, Access 2002 and
2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the subform.
When
this happens and there are no records to display in the subform, the
entire
detail section of the subform goes completely blank. Attempting to refer
to
the controls that do not exist in the subform then generates an error.

HTH

But it is showing an #Error when displaying the info. I have used this
in
other areas and it work but in this case it show an #Error. Can we turn
this
function off and make our changes.
--
Thanks

Craig


:

The square brackets around the names are optional, but Access will add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood
your
expression correctly. (If it puts quotes around something, it
indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put anything
it
keeps
putting [ ] around things I dont want. Help me before I go mad.

 

[Allen Browne]

CCur() forces Access to recognise the value as a currency type. Once it has
2 currency types, it can add them together.

CCur() fails on null, so the Nz() forces nulls to zero.

The expression therefore solves the case where Access misunderstands the
data types. It also solves the case where no result is shown if either value
is null, because Null + 99 = Null.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

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

Hi Allan, I tried your control

=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))

and YES!!!!!!! it worked.

Thank you so much for your help.

PS: Can you explain why this worked (only if you have time).

Once again THANK YOU.

--
Thanks

Craig

Okay, so both halves work alone, but the combination does not?

That suggests Access does not perceive them as the same data type, and
therefore cannot add them.

I understand tqdsell and Tqdgst to be text boxes in your subform.
Are they bound to fields in a table?
If so, what data types are the 2 fields?

Are they bound to calculated fields in a query, or to an expression?
If so, try typecasting the calculation in the query or in the
ControlSource,
as described here:
http://allenbrowne.com/ser-45.html
You could also help Access understand the intended data type by setting
the
Format property of the text boxes to Currency or General Number or some
such.

You could also try:
=CCur(Nz([quotedetails].[Form]![tqdsell],0)) +
CCur(Nz([quotedetails].[Form]![Tqdgst],0))


A further way to get Access to tell you how it understands these fields
would be to open the Immediate window, and enter:
? TypeName(Forms![YourMainFormNameHere].quotedetails.Form!tqdsell)

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

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

Hi Allan, I have checked everything but still no go.

=[quotedetails].[Form]![tqdsell] - This works

=[quotedetails].[Form]![Tqdgst] - This works

They are field in the subform.

Yes still not working and still driving me MAD.

PS: Thanks for your help so far


--
Thanks

Craig


:

The #Error is not caused by the square brackets, but by a problem such
incorrect naming, referring to non-existent objects, or inappropriate
data
types.

Firstly, make sure you have unchecked the boxes under:
Tools | Options | General | Name AutoCorrect
Those things will thoroughly confuse Access, let alone you.
For a list of some of the problems it generates see:
http://allenbrowne.com/bug-03.html
I suggest you compact the database after unchecking those boxes.

Now open the form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of the
subform
control? Its Name can be different from its SourceObject (i.e. the
name
of
the form that gets loaded into the control.)

If that's correct, try just getting one of the subform controls, e.g.:
=[quotedetails].[Form]![tqdsell]
This breaks the problem in half, so you can identify where the issue
lies.

BTW, is tsdsell a control in the subform, or just a field in the
subform's
RecordSource. If there is not a *control* by that name, Access 2002
and
2003
may have problems in trying to refer to it.

Another situation arises if new records cannot be added to the
subform.
When
this happens and there are no records to display in the subform, the
entire
detail section of the subform goes completely blank. Attempting to
refer
to
the controls that do not exist in the subform then generates an error.

HTH

But it is showing an #Error when displaying the info. I have used
this
in
other areas and it work but in this case it show an #Error. Can we
turn
this
function off and make our changes.
--
Thanks

Craig


:

The square brackets around the names are optional, but Access will
add
them
to your expression in certain contexts.

They won't hurt: in fact, they indicate that Access has understood
your
expression correctly. (If it puts quotes around something, it
indicates
Access has misunderstood it as a literal instead of an object.)

Hi I have a text box on a form and when trying to change the
control
source
it keeps reverting back.

I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst

But keeps going back to:
=[quotedetails].[Form]![tqdsell]+[quotedetails].[Form]![Tqdgs]

I can delete it all and nothing comes back but when I put
anything
it
keeps
putting [ ] around things I dont want. Help me before I go mad.