Saving Values from Combo Boxes in a Table

[sidewinder2]

I am making an Access form with a few combo boxes and text boxes. I have them set up to submit to a table when a button is clicked. The only issue is that the ID numbers from the values in the combo boxes are saved to the table instead of the displayed options in the drop down menu. I was wondering if it is possible to change this. Also, I am new to Access so forgive me if this is a simple issue. I wasn't able to find anything relating to my issue from Google or this forum. Thanks!

[June7]

If you don't want to save the ID values, don't include field in the combobox RowSource. Is the RowSource referencing a table or is it an SQL statement?

Are you saving to a number or text field? Is the other data text?

[sidewinder2]

The RowSource is referencing a table. The other data is text, and it is being saved to a text field.

If you don't want to save the ID values, don't include field in the combobox RowSource. Is the RowSource referencing a table or is it an SQL statement?

Are you saving to a number or text field? Is the other data text?

[June7]

Make the RowSource an SQL statement that selects only the field with data you want to save, like:

SELECT fieldName FROM tableName;

[sidewinder2]

I made everything so far using wizards as opposed to VBA, so I am not very familiar with that.

[June7]

Exactly why I never learned with the wizards. I also don't like what they do (use macros, 'group' controls, etc.)

You can type SQL statement into the RowSource or click the ellipses (...) to open query builder.

[sidewinder2]

Would it be possible for you to send a screenshot of what you are talking about? I'm having trouble visualizing it.

[June7]

Review http://datapigtechnologies.com/flash...combobox1.html

How to set RowSource is about halfway through the video.

[sidewinder2]

Lovely, that works, but brought up another issue. When the combo box is opened, the options are blank. But you can still select the blank spaces and it works.

[June7]

There are no items in the combobox dropdown? Why? Post your RowSource statement.

What are other properties set to:

ColumnCount
ColumnWidths
BoundColumn

[sidewinder2]

RowSource: SELECT Operators.[Machine Operators] FROM Operators ORDER BY Operators.[Machine Operators];

ColumnCount: 2
ColumnWidths: 0";1"
BoundColumn: 1

[June7]

Should be:

ColumnCount: 1
ColumnWidths: {1 column, no need to set}

[sidewinder2]

Success! Thank you very much!!