Combo boxes / control source problem

[jason123]

I have a drop down (combo) box on a data entry form which get the options for by querying a table Using the simple select query:

Row Source Type: Table/Query
Row Source: SELECT IssueName.SoftwareIssueCat FROM IssueName;

The field has its control source set to the field in the table which the form is used to enter data for. When the form writes the record to the table it saves all the options generated by the query with the one which was selected highlighted somehow. This is not what I want (though the only place it causes me real trouble so far is reports.)

What is the best way to only save the selected option to the table? I would guess this is a very common access mistake.


I read through a bunch of combobox posts, but couldn't find one that directly related to my issue.

 

[pbaldy]

Are you sure it's saving all the values? I've never seen that. If I had to guess, you created a lookup field in the table, and you're seeing the available options in the other table.

 

[jason123]

Are you sure it's saving all the values? I've never seen that. If I had to guess, you created a lookup field in the table, and you're seeing the available options in the other table.

Doh, you are right. That was silly of me. What can I say I haven't used access since school which was a long time ago. They need a head smacking emoticon.

 

[pbaldy]

They need a head smacking emoticon.

They can't; it would get over-used and wear out too quickly.