ComboBox Unwanted (help-a-newbe)

[cwalter]

Greetings!
When creating a form with the wizard, a field which refers to a table column related to a lookup table, creates a combobox by default. I realize that it is possible to lock the combo but, is there a way of creating a simple test field instead?

Thank you!

 

[PaddyIrishMan]

Right click on the combo & select Change to -> Textbox
HTH,
Patrick

 

[Ally]

Just curious: Why have you got it as a lookup field in the first place if you don't want it as a combo box? Not exactly sure what you mean by "test field", but hopefully the following will help. (Oh did you mean text field?)

There are a couple of ways round this. Either:

a) change your field at table level to a non-lookup ie, just have it as a number (or whatever the bound field is) but keep the relationship in the relationships.

Or b) keep it as a lookup, but in your form you can change your combo box to a text box by right-hand clicking it in design view > change to > text box. This would display the field as the bound column only, so you would need to pull the table into a query in order to display the 2nd column data as a separate field. (If that doesn't make any sense to you post back).

 

[cwalter]

Thanks Paddy and Ally

That did it.
I need to be adopted for a short period of time.
My boss has overestimated my abilities with MSAccess
and he is expecting results far beyond my knowledge.
The pressure - and a very thick book - have made
miracles I must say, but I still need to ask funny questions,
because of the time constraint.
Please bear with me.

All the Best
ContiW

 

[Ally]

No worries - we'll adopt you!

 

[bluenose76]

This is exactly what I am trying to achive, I have followed what the instructions have said and change my lookup field to a text field but kept the relationship, I cannot however get the text box to populate with the correct information.

My form is allready based upon a query but i only see the correct result in the query and not the "bound column" you talk about, however in my form i do get the numeric entry that referes to a bound column,

When the field is set to a combobox i can see the bound column but when set to a text box i cannot?

Please advise

Just curious: Why have you got it as a lookup field in the first place if you don't want it as a combo box? Not exactly sure what you mean by "test field", but hopefully the following will help. (Oh did you mean text field?)

There are a couple of ways round this. Either:

a) change your field at table level to a non-lookup ie, just have it as a number (or whatever the bound field is) but keep the relationship in the relationships.

Or b) keep it as a lookup, but in your form you can change your combo box to a text box by right-hand clicking it in design view > change to > text box. This would display the field as the bound column only, so you would need to pull the table into a query in order to display the 2nd column data as a separate field. (If that doesn't make any sense to you post back).