Combo Box question

A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you
create a new record you can select the text desc from the combo box with no
problems. She then saves the record and closes the form. Now when she tries
to reopen the form and select an existing record nothing is showing up in the
combo box, though the value is stored in the table.

She would like to know what can be done so the combo box will show the value
from the first column(text desc) for an existing record.

Any help would be greatly appreciated.

Dan

Are there controls on the form that are bound to the text desc and number id
fields?
Is the combo box unbound?
Does the combo box have two columns - one for each field?
What is the order of the columns in the combo? Which column of the combo is
the bound column?
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you
create a new record you can select the text desc from the combo box with no
problems. She then saves the record and closes the form. Now when she tries
to reopen the form and select an existing record nothing is showing up in the
combo box, though the value is stored in the table.

She would like to know what can be done so the combo box will show the value
from the first column(text desc) for an existing record.

Any help would be greatly appreciated.

Dan

combo box is bound to a number field. Second field is bound field which is
number also. But first field is the text that is displayed when selecting the
value. I also want to see text value for saved records.

"Klatuu" wrote:

Are there controls on the form that are bound to the text desc and number id
fields?
Is the combo box unbound?
Does the combo box have two columns - one for each field?
What is the order of the columns in the combo? Which column of the combo is
the bound column?
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you
create a new record you can select the text desc from the combo box with no
problems. She then saves the record and closes the form. Now when she tries
to reopen the form and select an existing record nothing is showing up in the
combo box, though the value is stored in the table.

She would like to know what can be done so the combo box will show the value
from the first column(text desc) for an existing record.

Any help would be greatly appreciated.

Dan

Sorry, Dan, I got a bit lost in this.
Please tell me the names of the field in the table.
The names of the controls on the form.
Show which table field is bound to which form control.
Post the row source for the combo box.
Which column in the combo box is the bound column?

If you can provide that, I think I can work out the problem.
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

combo box is bound to a number field. Second field is bound field which is
number also. But first field is the text that is displayed when selecting the
value. I also want to see text value for saved records.

"Klatuu" wrote:

Are there controls on the form that are bound to the text desc and number id
fields?
Is the combo box unbound?
Does the combo box have two columns - one for each field?
What is the order of the columns in the combo? Which column of the combo is
the bound column?
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you
create a new record you can select the text desc from the combo box with no
problems. She then saves the record and closes the form. Now when she tries
to reopen the form and select an existing record nothing is showing up in the
combo box, though the value is stored in the table.

She would like to know what can be done so the combo box will show the value
from the first column(text desc) for an existing record.

Any help would be greatly appreciated.

Dan

Dave,

Thanks for the help.
While posting the information here she found another solution to the problem.
I don't know all the details.

Thanks again

Dan

"Klatuu" wrote:

Sorry, Dan, I got a bit lost in this.
Please tell me the names of the field in the table.
The names of the controls on the form.
Show which table field is bound to which form control.
Post the row source for the combo box.
Which column in the combo box is the bound column?

If you can provide that, I think I can work out the problem.
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

combo box is bound to a number field. Second field is bound field which is
number also. But first field is the text that is displayed when selecting the
value. I also want to see text value for saved records.

"Klatuu" wrote:

Are there controls on the form that are bound to the text desc and number id
fields?
Is the combo box unbound?
Does the combo box have two columns - one for each field?
What is the order of the columns in the combo? Which column of the combo is
the bound column?
--
Dave Hargis, Microsoft Access MVP


"Dan" wrote:

A coworker is developing a access application which has a combo box on a form
that is bound to a table with two columns (text desc, number id). When you
create a new record you can select the text desc from the combo box with no
problems. She then saves the record and closes the form. Now when she tries
to reopen the form and select an existing record nothing is showing up in the
combo box, though the value is stored in the table.

She would like to know what can be done so the combo box will show the value
from the first column(text desc) for an existing record.

Any help would be greatly appreciated.

Dan