i want use combo box as text also it should work not in the list option.

[alex_raju]

hi,



i have a combo box in my sales invoice form to select PRODUCT ID and i have given not in the list option. so, created product id only allowed. but now i changed combo box to text ( to be good look), now if i enter product id it is working as before but not in the list is not working. please help me to i want use combo box as text also it should work whatever created data only can be valid.

thank you
alex

[June7]

Show these properties of the combobox:
RowSource
BoundColumn
Column Widths
NumberOfColumns
ControlSource

[alex_raju]

[June7]

alex, your last post shows no info. Just type the properties into post.

[alex_raju]

RowSource=========== table/query
BoundColumn=========1
Column Widths========0";2.2";1"
NumberOfColumns(columns count)===3
ControlSource========SELECT DISTINCT ProductID, ProductName, Discontinued FROM Products ORDER BY [ProductName];

[June7]

What you show as ControlSource is actually RowSource.

What you show as RowSource is actually RowSourceType.

What is the ControlSource? This should be field in table.

You have LimitToList set to Yes? AutoExpand set to Yes?

[alex_raju]

hi sir,

my database ( forms, table, etc..) working perfect, nothing wrong, just i want to know presently i am using a combo box with not in the list potion, now i want change that combo box to text box and i want apply same or like not in the list option.

[June7]

A textbox does not have a list so that option is not available. It has ValidationRule property where you can put criteria for valid data, such as: >0 And <100. Otherwise, use the textbox BeforeUpdate event for code to check the entered value meets criteria.

Why not stay with the combobox?

[alex_raju]

A textbox does not have a list so that option is not available. It has ValidationRule property where you can put criteria for valid data, such as: >0 And <100. Otherwise, use the textbox BeforeUpdate event for code to check the entered value meets criteria.

Why not stay with the combobox?

thank you.