New user question on forms

[Phil]

As a new user, I was pleased I was able to build tables and connect them
properly (I think), but am having one problem on forms. How does one go
about creating a form, where on field on the form is a combo box, where the
selections in that box are from a table? I selected Table/Query in
Properties for the combo box field. When using the combo box, all I get are
numbers (1 - 7). I do have 7 entries in the table, but am not seeing the
actual values. I just see the apparent corresponding numbers for those
values. How do I get the actual values (not the numbers) to show in the
combo box?

Thank you,

- Phil

[Mal Reeve]

Its the number of colums displayed, as well as their size (ie. you can have
2 columns - id & actual value -but have sizes of 0" & 2"...to hide the
number, show the value)
BUT
the easiest way is to make sure that the wizards are turned on (Lightning
bolt button in toolbar) then when you place a combo box the wizard will walk
you through all of it.

Mal.
"Phil" <p.*****@comcast.net> wrote in message
news:JECCc.171675$Ly.137257@attbi_s01...

As a new user, I was pleased I was able to build tables and connect them
properly (I think), but am having one problem on forms. How does one go
about creating a form, where on field on the form is a combo box, where the selections in that box are from a table? I selected Table/Query in
Properties for the combo box field. When using the combo box, all I get are numbers (1 - 7). I do have 7 entries in the table, but am not seeing the
actual values. I just see the apparent corresponding numbers for those
values. How do I get the actual values (not the numbers) to show in the
combo box?

Thank you,

- Phil

[Phil]

I am not seeing any lightning bolt on any tool bar, but I can't find where
it is to install on the tool bar. I presume at some point when I try to
turn a field into a combo box, I click the wizard and it assists? Sorry for
the naive questions, but quite new at this.

- Phil

"Mal Reeve" <lo*****@earthlink.net> wrote in message
news:Ny*****************@newsread2.news.atl.earthl ink.net...

Its the number of colums displayed, as well as their size (ie. you can have 2 columns - id & actual value -but have sizes of 0" & 2"...to hide the
number, show the value)
BUT
the easiest way is to make sure that the wizards are turned on (Lightning
bolt button in toolbar) then when you place a combo box the wizard will walk you through all of it.

Mal.
"Phil" <p.*****@comcast.net> wrote in message
news:JECCc.171675$Ly.137257@attbi_s01...

As a new user, I was pleased I was able to build tables and connect them
properly (I think), but am having one problem on forms. How does one go
about creating a form, where on field on the form is a combo box, where

the

selections in that box are from a table? I selected Table/Query in
Properties for the combo box field. When using the combo box, all I get

are

numbers (1 - 7). I do have 7 entries in the table, but am not seeing the actual values. I just see the apparent corresponding numbers for those
values. How do I get the actual values (not the numbers) to show in the
combo box?

Thank you,

- Phil

[Salad]

Phil wrote:

I am not seeing any lightning bolt on any tool bar, but I can't find where
it is to install on the tool bar. I presume at some point when I try to
turn a field into a combo box, I click the wizard and it assists? Sorry for
the naive questions, but quite new at this.

- Phil

"Mal Reeve" <lo*****@earthlink.net> wrote in message
news:Ny*****************@newsread2.news.atl.earthl ink.net...

Its the number of colums displayed, as well as their size (ie. you can

have

2 columns - id & actual value -but have sizes of 0" & 2"...to hide the
number, show the value)
BUT
the easiest way is to make sure that the wizards are turned on (Lightning
bolt button in toolbar) then when you place a combo box the wizard will

walk

you through all of it.

Mal.
"Phil" <p.*****@comcast.net> wrote in message
news:JECCc.171675$Ly.137257@attbi_s01...

As a new user, I was pleased I was able to build tables and connect them
properly (I think), but am having one problem on forms. How does one go
about creating a form, where on field on the form is a combo box, where

the

selections in that box are from a table? I selected Table/Query in
Properties for the combo box field. When using the combo box, all I get

are

numbers (1 - 7). I do have 7 entries in the table, but am not seeing
the
actual values. I just see the apparent corresponding numbers for those
values. How do I get the actual values (not the numbers) to show in the
combo box?

Thank you,

- Phil

Get the property sheet open for the Combo. On the Data tab, you should
see RowSource. Click on that row, then the triple-dot to update the
query of the rowsource. You can tell which column to use to store data
to the field; 1 = 1st field in query, 2 = 2nd field in query...etc.

Next, click to Format tab. If you have 5 fields in the query, enter 5
into column count. Then set the widths. Let's say the first field is an
autonumber field and you don't want to display it. The other 4 are 1
inch in width. Enter
0;1;1;1;1
into the ColumnWidths row.

[Mal Reeve]

Sorry.,,,I gave you a bum steer...

From the Design View of the form....click View...Toolbox (unless its already
visible)
At the top (floating Menu) or at the left (toolbar menu) there is an
arrow...and a wand with stars coming from it...that's the Control Wizards..
Make sure the Wand is clicked ...then add a combo box and see it go to work.

Mal.

"Salad" <oi*@vinegar.com> wrote in message
news:Hj******************@newsread2.news.pas.earth link.net...

Phil wrote:

I am not seeing any lightning bolt on any tool bar, but I can't find where it is to install on the tool bar. I presume at some point when I try to
turn a field into a combo box, I click the wizard and it assists? Sorry for the naive questions, but quite new at this.

- Phil

"Mal Reeve" <lo*****@earthlink.net> wrote in message
news:Ny*****************@newsread2.news.atl.earthl ink.net...

Its the number of colums displayed, as well as their size (ie. you can

have

2 columns - id & actual value -but have sizes of 0" & 2"...to hide the
number, show the value)
BUT
the easiest way is to make sure that the wizards are turned on (Lightningbolt button in toolbar) then when you place a combo box the wizard will

walk

you through all of it.

Mal.
"Phil" <p.*****@comcast.net> wrote in message
news:JECCc.171675$Ly.137257@attbi_s01...

As a new user, I was pleased I was able to build tables and connect themproperly (I think), but am having one problem on forms. How does one goabout creating a form, where on field on the form is a combo box, where

the

selections in that box are from a table? I selected Table/Query in
Properties for the combo box field. When using the combo box, all I get
are

numbers (1 - 7). I do have 7 entries in the table, but am not seeing

the

actual values. I just see the apparent corresponding numbers for those
values. How do I get the actual values (not the numbers) to show in thecombo box?

Thank you,

- Phil

Get the property sheet open for the Combo. On the Data tab, you should
see RowSource. Click on that row, then the triple-dot to update the
query of the rowsource. You can tell which column to use to store data
to the field; 1 = 1st field in query, 2 = 2nd field in query...etc.

Next, click to Format tab. If you have 5 fields in the query, enter 5
into column count. Then set the widths. Let's say the first field is an
autonumber field and you don't want to display it. The other 4 are 1
inch in width. Enter
0;1;1;1;1
into the ColumnWidths row.