Remedial Combo-box question.

[pellep]

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[Golfinray]

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

 

[pellep]

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[Beetle]

Open the properties for sheet for your combo box and go to the Data tab.
Check the "Locked" property and make sure it did not somehow get
set to Yes.
--
_________

Sean Bailey

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[pellep]

Check it, it is set to "Yes", but thanks. Like I said I can use the drop
down arrow and see all my data, but that's all I can do. I know this has to
be something really obvious, but I just can't see it. Thanks anyways. At
this point I am open to ALL suggestions.

Open the properties for sheet for your combo box and go to the Data tab.
Check the "Locked" property and make sure it did not somehow get
set to Yes.
--
_________

Sean Bailey

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

:

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[Beetle]

Then that's the problem. In my previous post I said make sure it is *not*
set to Yes. Change it to No.
--
_________

Sean Bailey

Check it, it is set to "Yes", but thanks. Like I said I can use the drop
down arrow and see all my data, but that's all I can do. I know this has to
be something really obvious, but I just can't see it. Thanks anyways. At
this point I am open to ALL suggestions.

Open the properties for sheet for your combo box and go to the Data tab.
Check the "Locked" property and make sure it did not somehow get
set to Yes.
--
_________

Sean Bailey

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

:

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

:

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[pellep]

Thanks for your time Sean, but I still can't seem to get past this. I have
tried it both ways and I can still "see" my options to choose from, but that
is all. It must be something universally wrong I am doing, because I tried
to just start over with a simplier combo box and I am getting the same "view
only" issue there. I think I will go back to "home sweet home Excel" and
figure out a way to accomplish this there.

Thanks again.

Then that's the problem. In my previous post I said make sure it is *not*
set to Yes. Change it to No.
--
_________

Sean Bailey

Check it, it is set to "Yes", but thanks. Like I said I can use the drop
down arrow and see all my data, but that's all I can do. I know this has to
be something really obvious, but I just can't see it. Thanks anyways. At
this point I am open to ALL suggestions.

Open the properties for sheet for your combo box and go to the Data tab.
Check the "Locked" property and make sure it did not somehow get
set to Yes.
--
_________

Sean Bailey


:

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

:

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

:

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.

 

[Names]

Hi,

Not sure if this is going to help any, but maybe you could check if, under
the data tab again, "Enabled" is set to "yes"?

Thanks for your time Sean, but I still can't seem to get past this. I have
tried it both ways and I can still "see" my options to choose from, but that
is all. It must be something universally wrong I am doing, because I tried
to just start over with a simplier combo box and I am getting the same "view
only" issue there. I think I will go back to "home sweet home Excel" and
figure out a way to accomplish this there.

Thanks again.

Then that's the problem. In my previous post I said make sure it is *not*
set to Yes. Change it to No.
--
_________

Sean Bailey

Check it, it is set to "Yes", but thanks. Like I said I can use the drop
down arrow and see all my data, but that's all I can do. I know this has to
be something really obvious, but I just can't see it. Thanks anyways. At
this point I am open to ALL suggestions.

:

Open the properties for sheet for your combo box and go to the Data tab.
Check the "Locked" property and make sure it did not somehow get
set to Yes.
--
_________

Sean Bailey


:

Thanks for the reply. I'll keep playing around, this didn't seem to work,
but you might have at least put me in the right diretion. My combo box
inputs data from a list I created "Check Type". All the options are showing,
it just won't let me choose any of them. I'm not sure what the combobox
number is, I'll keep looking.

Thanks again.

:

If you are trying to get the combo to look up values on your form, use this:
Right click on the combo and choose properties, choose event, afterupdate,
and then click the button to the right of afterupdate, and start the code
builder. Then type:
Me.filter = "[yourfield] = """ & Me.combo# & """"
Me.filteron = true

Yourfield is whatever field you are searching on and combo number will be
listed like combo13 or combo6.

:

I'll keep looking on microsoft because I know this has to be something really
foolish I am doing. Good news - I have inserted a combo-box in my form. Bad
news - it shows the items listed, but does not allow my to choose any of
them. I'm sure this is something in the properties, but if anyone knows
what I am doing wrong, I'de appreciate a comment or too. Thanks goodness we
don't have to use real names, I'm sure this one is so simple it should be
embarassing.

Thanks.