ComboBox not functioning as expected

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

I've got a combo box which shows no value after the user has picked an item
from the dropdown list; I'm certain this is an easy problem (perhaps to
easy)

- the combo gets its data from a table with 2 fields: "common name" &
"ReportName"
- the field widths are: [2";0"]
- the value is for future use (not stored in a field), consequently, it is
unbound; it will provide the value used in a command button's code (the
button is located elsewhere on the form) .
- the value that will be used is the second ("ReportName")

thanks in advance,
mark
 
Uhmmmm...

Your field widths are 2" and 0".

Your fields are [CommonName] and [ReportName].

The field to be displayed is the second one.

Wait, you said the second one is 0" wide, right? <g>

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
i want to use the value of the second one [ReportName], but display the
value of the first [CommonName]

for example the [CommonName] might be "Fixture Schedule", but the
[ReportName], to be used inthe code is "rptSchedule_Fixture"

(does this help clarify?)
-m.


Jeff Boyce said:
Uhmmmm...

Your field widths are 2" and 0".

Your fields are [CommonName] and [ReportName].

The field to be displayed is the second one.

Wait, you said the second one is 0" wide, right? <g>

Regards

Jeff Boyce
Microsoft Office/Access MVP


Mark Kubicki said:
I've got a combo box which shows no value after the user has picked an
item from the dropdown list; I'm certain this is an easy problem
(perhaps to easy)

- the combo gets its data from a table with 2 fields: "common name" &
"ReportName"
- the field widths are: [2";0"]
- the value is for future use (not stored in a field), consequently, it
is unbound; it will provide the value used in a command button's code
(the button is located elsewhere on the form) .
- the value that will be used is the second ("ReportName")

thanks in advance,
mark
Click to expand...
Click to expand...
 
Mark

If this were mine, I'd ... "play" with it a bit.

What happens if both fields are 2" wide?

Which field is the "bound" field?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Mark Kubicki said:
i want to use the value of the second one [ReportName], but display the
value of the first [CommonName]

for example the [CommonName] might be "Fixture Schedule", but the
[ReportName], to be used inthe code is "rptSchedule_Fixture"

(does this help clarify?)
-m.


Jeff Boyce said:
Uhmmmm...

Your field widths are 2" and 0".

Your fields are [CommonName] and [ReportName].

The field to be displayed is the second one.

Wait, you said the second one is 0" wide, right? <g>

Regards

Jeff Boyce
Microsoft Office/Access MVP


Mark Kubicki said:
I've got a combo box which shows no value after the user has picked an
item from the dropdown list; I'm certain this is an easy problem
(perhaps to easy)

- the combo gets its data from a table with 2 fields: "common name" &
"ReportName"
- the field widths are: [2";0"]
- the value is for future use (not stored in a field), consequently, it
is unbound; it will provide the value used in a command button's code
(the button is located elsewhere on the form) .
- the value that will be used is the second ("ReportName")

thanks in advance,
mark
Click to expand...
Click to expand...
Click to expand...
 
Back
Top