Not in fieldlist

[CurtainMary]

I have a combo box on a form based on a query. After using the Expression
builder an equal sign is automatically inserted in front of the field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This means that
the combo box no longer displays the name. By removing the = from the field
itself then save, it works fine. I have the feeling that there is something
not quite a 100%. A little marker tells me that it is not in the field list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[Duane Hookom]

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source dropdown.

 

[CurtainMary]

Thanks for responding Duane. The problem is that I created the field on the
form just as you said using the field list created by the query. I had to use
the properties box Format to set the first column to 0 (zero) in order to
display the surname. When I close the properties, that = appears.
CurtainMary

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source dropdown.


--
Duane Hookom
MS Access MVP

I have a combo box on a form based on a query. After using the Expression
builder an equal sign is automatically inserted in front of the field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This means
that
the combo box no longer displays the name. By removing the = from the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[Duane Hookom]

What do you mean by "set the first column to 0"? Are you talking about the
Column Widths property? The bound column of the combo box determines which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control Source
property.


--
Duane Hookom
MS Access MVP

Thanks for responding Duane. The problem is that I created the field on
the
form just as you said using the field list created by the query. I had to
use
the properties box Format to set the first column to 0 (zero) in order to
display the surname. When I close the properties, that = appears.
CurtainMary

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source dropdown.


--
Duane Hookom
MS Access MVP

I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This means
that
the combo box no longer displays the name. By removing the = from the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[CurtainMary]

Thanks for coming back Duane. Yes I was talking about the ColumnWidth
property. The bound column's number does indeed get stored in the main table
when I make sure that the = sign gets removed. I wonder if it may be caused
by the fact that the PersonnelID in the main table is not always required, I
have some records that are not linked to a person and I have set the field in
the tblSample Required equals No
CurtainMary

What do you mean by "set the first column to 0"? Are you talking about the
Column Widths property? The bound column of the combo box determines which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control Source
property.


--
Duane Hookom
MS Access MVP

Thanks for responding Duane. The problem is that I created the field on
the
form just as you said using the field list created by the query. I had to
use
the properties box Format to set the first column to 0 (zero) in order to
display the surname. When I close the properties, that = appears.
CurtainMary

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source dropdown.


--
Duane Hookom
MS Access MVP

I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This means
that
the combo box no longer displays the name. By removing the = from the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[Duane Hookom]

" I wonder if it may be caused by the fact that the PersonnelID in the main
table is not always required" What do you mean by "it"? Is there a question
remaining in this thread?

--
Duane Hookom
MS Access MVP

Thanks for coming back Duane. Yes I was talking about the ColumnWidth
property. The bound column's number does indeed get stored in the main
table
when I make sure that the = sign gets removed. I wonder if it may be
caused
by the fact that the PersonnelID in the main table is not always required,
I
have some records that are not linked to a person and I have set the field
in
the tblSample Required equals No
CurtainMary

What do you mean by "set the first column to 0"? Are you talking about
the
Column Widths property? The bound column of the combo box determines
which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control Source
property.


--
Duane Hookom
MS Access MVP

Thanks for responding Duane. The problem is that I created the field on
the
form just as you said using the field list created by the query. I had
to
use
the properties box Format to set the first column to 0 (zero) in order
to
display the surname. When I close the properties, that = appears.
CurtainMary

:

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source
dropdown.


--
Duane Hookom
MS Access MVP

I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the
field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This
means
that
the combo box no longer displays the name. By removing the = from
the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the
field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[CurtainMary]

Thanks again Duane. Sorry to be a pest. The "it" refers to the = sign being
added. The foreign key in tbleSample is joined to the primary key in
tblPersonnel. The property in tblSample is set to not required and I have
specified the join to (2) include all records from tblSample. I am just
worried that this = popping into the field means that there is some error
that may turn around one day and bite me.
CurtainMary

" I wonder if it may be caused by the fact that the PersonnelID in the main
table is not always required" What do you mean by "it"? Is there a question
remaining in this thread?

--
Duane Hookom
MS Access MVP

Thanks for coming back Duane. Yes I was talking about the ColumnWidth
property. The bound column's number does indeed get stored in the main
table
when I make sure that the = sign gets removed. I wonder if it may be
caused
by the fact that the PersonnelID in the main table is not always required,
I
have some records that are not linked to a person and I have set the field
in
the tblSample Required equals No
CurtainMary

What do you mean by "set the first column to 0"? Are you talking about
the
Column Widths property? The bound column of the combo box determines
which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control Source
property.


--
Duane Hookom
MS Access MVP


Thanks for responding Duane. The problem is that I created the field on
the
form just as you said using the field list created by the query. I had
to
use
the properties box Format to set the first column to 0 (zero) in order
to
display the surname. When I close the properties, that = appears.
CurtainMary

:

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source
dropdown.


--
Duane Hookom
MS Access MVP

I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the
field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This
means
that
the combo box no longer displays the name. By removing the = from
the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the
field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[Duane Hookom]

The "=" may be the result of using the Expression Builder. You should not be
using the Expression Builder to bind a control to a field. My first reply to
you provides two preferred methods.

--
Duane Hookom
MS Access MVP

Thanks again Duane. Sorry to be a pest. The "it" refers to the = sign
being
added. The foreign key in tbleSample is joined to the primary key in
tblPersonnel. The property in tblSample is set to not required and I have
specified the join to (2) include all records from tblSample. I am just
worried that this = popping into the field means that there is some error
that may turn around one day and bite me.
CurtainMary

" I wonder if it may be caused by the fact that the PersonnelID in the
main
table is not always required" What do you mean by "it"? Is there a
question
remaining in this thread?

--
Duane Hookom
MS Access MVP

Thanks for coming back Duane. Yes I was talking about the ColumnWidth
property. The bound column's number does indeed get stored in the main
table
when I make sure that the = sign gets removed. I wonder if it may be
caused
by the fact that the PersonnelID in the main table is not always
required,
I
have some records that are not linked to a person and I have set the
field
in
the tblSample Required equals No
CurtainMary

:

What do you mean by "set the first column to 0"? Are you talking about
the
Column Widths property? The bound column of the combo box determines
which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control
Source
property.


--
Duane Hookom
MS Access MVP


Thanks for responding Duane. The problem is that I created the field
on
the
form just as you said using the field list created by the query. I
had
to
use
the properties box Format to set the first column to 0 (zero) in
order
to
display the surname. When I close the properties, that = appears.
CurtainMary

:

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source
dropdown.


--
Duane Hookom
MS Access MVP

message
I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the
field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This
means
that
the combo box no longer displays the name. By removing the = from
the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the
field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary

 

[CurtainMary]

Thanks a lot Duane. The reason I looked at the Expression builder: when I
converted to Access2003 a month ago, in design mode there was a little green
triangle at the top LH corner which then indicated the error. Anyway I shall
leave it alone.
CurtainMary

The "=" may be the result of using the Expression Builder. You should not be
using the Expression Builder to bind a control to a field. My first reply to
you provides two preferred methods.

--
Duane Hookom
MS Access MVP

Thanks again Duane. Sorry to be a pest. The "it" refers to the = sign
being
added. The foreign key in tbleSample is joined to the primary key in
tblPersonnel. The property in tblSample is set to not required and I have
specified the join to (2) include all records from tblSample. I am just
worried that this = popping into the field means that there is some error
that may turn around one day and bite me.
CurtainMary

" I wonder if it may be caused by the fact that the PersonnelID in the
main
table is not always required" What do you mean by "it"? Is there a
question
remaining in this thread?

--
Duane Hookom
MS Access MVP

Thanks for coming back Duane. Yes I was talking about the ColumnWidth
property. The bound column's number does indeed get stored in the main
table
when I make sure that the = sign gets removed. I wonder if it may be
caused
by the fact that the PersonnelID in the main table is not always
required,
I
have some records that are not linked to a person and I have set the
field
in
the tblSample Required equals No
CurtainMary

:

What do you mean by "set the first column to 0"? Are you talking about
the
Column Widths property? The bound column of the combo box determines
which
value/column from the combo box will get stored in your form's record
source. This gets stored in the field in the combo box's Control
Source
property.


--
Duane Hookom
MS Access MVP


Thanks for responding Duane. The problem is that I created the field
on
the
form just as you said using the field list created by the query. I
had
to
use
the properties box Format to set the first column to 0 (zero) in
order
to
display the surname. When I close the properties, that = appears.
CurtainMary

:

If you want to bind a control on your form, you need to
-display/view the form's field list and drag a field to your form
-create a text box and select a field from the control source
dropdown.


--
Duane Hookom
MS Access MVP

message
I have a combo box on a form based on a query. After using the
Expression
builder an equal sign is automatically inserted in front of the
field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This
means
that
the combo box no longer displays the name. By removing the = from
the
field
itself then save, it works fine. I have the feeling that there is
something
not quite a 100%. A little marker tells me that it is not in the
field
list
but I picked it from the list.
This has been worrying me for some years, I might lose data.
Can anything be done?
CurtainMary