If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unbound combo box
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? |
#2
|
|||
|
|||
Unbound combo box
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. "HD53" wrote: 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? |
#3
|
|||
|
|||
Unbound combo box
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" wrote: 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. "HD53" wrote: 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? |
#4
|
|||
|
|||
Unbound combo box
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. "HD53" wrote: 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" wrote: 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. "HD53" wrote: 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? |
#5
|
|||
|
|||
Unbound combo box
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...... "Wayne-I-M" wrote: 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. "HD53" wrote: 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" wrote: 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. "HD53" wrote: 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? |
#6
|
|||
|
|||
Unbound combo box
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. "HD53" wrote: 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...... "Wayne-I-M" wrote: 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. "HD53" wrote: 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" wrote: 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. "HD53" wrote: 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? |
#7
|
|||
|
|||
Unbound combo box
Thank you Wayne, that was the problem; the Control source was not selected.
"Wayne-I-M" wrote: 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. "HD53" wrote: 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...... "Wayne-I-M" wrote: 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. "HD53" wrote: 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" wrote: 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. "HD53" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|