Unbound combo box

[HD53]

I have a combo box that when I select the job name, the associated
information shows in the form, but the combo box does not hold th job name.
If I select the job again, it stays in the box (highlighted). Am I missing
something in the properties that will keep the name I selected in the combo
box the 1st time?

 

[Wayne-I-M]

Hi

If it's really unbound it should hold the value you select.
Open the form in design view
Select the combo
Right click
Open the properties box
In the Data Column

What can you see in the Row Source Type
It should say
Value List

What can you see in the Row Source
It should look something like
"Row 1 detail";"Row 2 detail";"Row 3 detail";"Row 4 detail";"etc";"etc"

Can you copy these 2 rows and post them here
Then you should get an informative answer

 

[HD53]

Wayne,

the information you requested... Row source Type is Table/Query
Row source is Select[select].[job name] from [select]; FYI - 'select' is
the name of my table (I know, bad name.. did not think ahead) on which the
form is created.

I used the combo box wizard with "find a record on my form based on the
value I selected in my combo box."

I then picked "job nam" for Selected fields

 

[Wayne-I-M]

HI

1st thing to do is to change the name of the table, using Select will bring
many problems as this word is used in access applications codes. This may
take a while to do if you have used it many time in your application but
things will only get worst so change it now.

Next the combo is not unbound - it is bound to your table called select
(which you're going to rename ?)

Change the name of the table and it should be OK if you use
SELECT [NewTableName].[job name] FROM [NewTableName];




--
Wayne
Manchester, England.

Wayne,

the information you requested... Row source Type is Table/Query
Row source is Select[select].[job name] from [select]; FYI - 'select' is
the name of my table (I know, bad name.. did not think ahead) on which the
form is created.

I used the combo box wizard with "find a record on my form based on the
value I selected in my combo box."

I then picked "job nam" for Selected fields

Hi

If it's really unbound it should hold the value you select.
Open the form in design view
Select the combo
Right click
Open the properties box
In the Data Column

What can you see in the Row Source Type
It should say
Value List

What can you see in the Row Source
It should look something like
"Row 1 detail";"Row 2 detail";"Row 3 detail";"Row 4 detail";"etc";"etc"

Can you copy these 2 rows and post them here
Then you should get an informative answer

 

[HD53]

I renamed the Table to ProdTemp, changed the queries, forms and Combo box
(while in design view the combo box says 'unbound'), but I am still having
the original issue of the job name not staying in Combo box while the rest of
form shows the info for that specific job name.

I appreciate your patience......

HI

1st thing to do is to change the name of the table, using Select will bring
many problems as this word is used in access applications codes. This may
take a while to do if you have used it many time in your application but
things will only get worst so change it now.

Next the combo is not unbound - it is bound to your table called select
(which you're going to rename ?)

Change the name of the table and it should be OK if you use
SELECT [NewTableName].[job name] FROM [NewTableName];




--
Wayne
Manchester, England.

Wayne,

the information you requested... Row source Type is Table/Query
Row source is Select[select].[job name] from [select]; FYI - 'select' is
the name of my table (I know, bad name.. did not think ahead) on which the
form is created.

I used the combo box wizard with "find a record on my form based on the
value I selected in my combo box."

I then picked "job nam" for Selected fields

Hi

If it's really unbound it should hold the value you select.
Open the form in design view
Select the combo
Right click
Open the properties box
In the Data Column

What can you see in the Row Source Type
It should say
Value List

What can you see in the Row Source
It should look something like
"Row 1 detail";"Row 2 detail";"Row 3 detail";"Row 4 detail";"etc";"etc"

Can you copy these 2 rows and post them here
Then you should get an informative answer


--
Wayne
Manchester, England.



:

I have a combo box that when I select the job name, the associated
information shows in the form, but the combo box does not hold th job name.
If I select the job again, it stays in the box (highlighted). Am I missing
something in the properties that will keep the name I selected in the combo
box the 1st time?

 

[Wayne-I-M]

Sounds a little strange.
Open the form in design view again. Right click the combo and in the data
column of the properties box check that the field you want is shown in the
Control Source Row - there will be a drop down to select from the available
fields.

If this fails then try adding a new combo and see what happens. This
"should" be really simple so I am a little lost as to why it's not working

--
Wayne
Manchester, England.

I renamed the Table to ProdTemp, changed the queries, forms and Combo box
(while in design view the combo box says 'unbound'), but I am still having
the original issue of the job name not staying in Combo box while the rest of
form shows the info for that specific job name.

I appreciate your patience......

HI

1st thing to do is to change the name of the table, using Select will bring
many problems as this word is used in access applications codes. This may
take a while to do if you have used it many time in your application but
things will only get worst so change it now.

Next the combo is not unbound - it is bound to your table called select
(which you're going to rename ?)

Change the name of the table and it should be OK if you use
SELECT [NewTableName].[job name] FROM [NewTableName];




--
Wayne
Manchester, England.

Wayne,

the information you requested... Row source Type is Table/Query
Row source is Select[select].[job name] from [select]; FYI - 'select' is
the name of my table (I know, bad name.. did not think ahead) on which the
form is created.

I used the combo box wizard with "find a record on my form based on the
value I selected in my combo box."

I then picked "job nam" for Selected fields

:

Hi

If it's really unbound it should hold the value you select.
Open the form in design view
Select the combo
Right click
Open the properties box
In the Data Column

What can you see in the Row Source Type
It should say
Value List

What can you see in the Row Source
It should look something like
"Row 1 detail";"Row 2 detail";"Row 3 detail";"Row 4 detail";"etc";"etc"

Can you copy these 2 rows and post them here
Then you should get an informative answer


--
Wayne
Manchester, England.



:

I have a combo box that when I select the job name, the associated
information shows in the form, but the combo box does not hold th job name.
If I select the job again, it stays in the box (highlighted). Am I missing
something in the properties that will keep the name I selected in the combo
box the 1st time?

 

[HD53]

Thank you Wayne, that was the problem; the Control source was not selected.

Sounds a little strange.
Open the form in design view again. Right click the combo and in the data
column of the properties box check that the field you want is shown in the
Control Source Row - there will be a drop down to select from the available
fields.

If this fails then try adding a new combo and see what happens. This
"should" be really simple so I am a little lost as to why it's not working

--
Wayne
Manchester, England.

I renamed the Table to ProdTemp, changed the queries, forms and Combo box
(while in design view the combo box says 'unbound'), but I am still having
the original issue of the job name not staying in Combo box while the rest of
form shows the info for that specific job name.

I appreciate your patience......

HI

1st thing to do is to change the name of the table, using Select will bring
many problems as this word is used in access applications codes. This may
take a while to do if you have used it many time in your application but
things will only get worst so change it now.

Next the combo is not unbound - it is bound to your table called select
(which you're going to rename ?)

Change the name of the table and it should be OK if you use
SELECT [NewTableName].[job name] FROM [NewTableName];




--
Wayne
Manchester, England.



:

Wayne,

the information you requested... Row source Type is Table/Query
Row source is Select[select].[job name] from [select]; FYI - 'select' is
the name of my table (I know, bad name.. did not think ahead) on which the
form is created.

I used the combo box wizard with "find a record on my form based on the
value I selected in my combo box."

I then picked "job nam" for Selected fields

:

Hi

If it's really unbound it should hold the value you select.
Open the form in design view
Select the combo
Right click
Open the properties box
In the Data Column

What can you see in the Row Source Type
It should say
Value List

What can you see in the Row Source
It should look something like
"Row 1 detail";"Row 2 detail";"Row 3 detail";"Row 4 detail";"etc";"etc"

Can you copy these 2 rows and post them here
Then you should get an informative answer


--
Wayne
Manchester, England.



:

I have a combo box that when I select the job name, the associated
information shows in the form, but the combo box does not hold th job name.
If I select the job again, it stays in the box (highlighted). Am I missing
something in the properties that will keep the name I selected in the combo
box the 1st time?