Changing textboxes to combo boxes in MS Access 2010

[Lou_Reed]

I am looking to change some textboxes to combboxes in MS Access 2010.

My internet search has not given any useful results (yes, Google failed me!).



So in MS Access 2010: how do I do it?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[June7]

Options:

1. delete textbox, create combobox

2. right click on textbox > Change To > Combobox - you will have to set combobox properties

[Lou_Reed]

I know that and that is what I am concerned about. The combo box has a list of values that the analysts selects from.
He should not put in any values, just select from a list. So how is that put in?

I hope that I am not confusing combo box with list box.

Thanks in advance.

Respectfully,


Lou Reed

[June7]

Combobox and Listbox both have RowSource, RowSourceType, ColumnCount, ColumnWidths, BoundColumn, ControlSource properties. These properties define the 'list'. It can be based on a query or a set of typed in values.

Basic Access functionality. Should have already encountered a tutorial on building combobox. Listbox is built same way.

[Lou_Reed]

Is changing combo box's (that was previously a text box) properties the same as building a combo box?

Thanks in advance.

Respectfully,


Lou Reed

[June7]

Yes. The 'Change To' feature is really minimally helpful. It allows retention of ControlSource and some other property settings, such as FontName. But properties not pertinent to textbox will have to be set.

[Lou_Reed]

How do I hide a primary key when making a form. The primary key is usually a single digit number and it travels with something like employee number and employee first name and last name. These last three things are what I want to see. In fact I am not sure of the need for an EmployeeID; shouldn't the Employee # (which is 5 digit) be sufficient? It seems this is superfluous. Also. in the combo box I want to see the employee number that helps me connect to that employee. What is EmployeeID needed for?

I think that again there might be an error in the tutorial. There is no need for an EmployeeID; if you have an employee number. The EmployeeID is the primary key though.


Any help appreciated. Thanks in advance.


Respectfully,


Lou Reed

[June7]

Hide PK in combobox list? Review http://datapigtechnologies.com/flash...combobox3.html