Using ComboBox to select value, how to add a text prefix to the value stored in the field

[ConnieZ]

One thing you'll hopefully learn is to think ahead of your needs and plan accordingly. Very often whats percieved as a minor little addition results in a total re-write of hundreds of lines of code and forms. Thats part of the reason I pointed it out.


As you become more familiarized with the forums you'll see it is full of posts looking for work-arounds trying to fix what should have been planned for from the get-go.

I'm assuming your constructing your CSV with a looped recordset. That is where you would add the prefix string to your csv, on demand, as needed.

If in the future you wanted to change it, you would only have to do it in one place, and not re-write the form, combobox and code, as well as updating all the records in your table.

Thank you for both of those suggestions. 1.) Do it right from the start 2.) Using a Looped Recordset (I have no idea what that is, but am about to look it up.) That will probably meet other data needs I have as well, such as needing to input "1" in a .csv field, which means "Yes", because I want the user to be able to just pick Yes.

... Connie Z

[orange]

There are several articles and tutorial links in the Database Planning and Design link in my signature that may help.

[Missinglinq]

BTW, how do handle Puerto Rico and Washington DC which are not states?

Sadly...Puerto Rico is still reeling from a plethora of natural disasters...and not producing much of anything for export!

And D.C., of course, produces little except Political B.S., and I can't imagine anyone needing to order more of that...just turn on the TV!

Linq ;0)>

[moke123]

Sadly...Puerto Rico is still reeling from a plethora of natural disasters...and not producing much of anything for export!

And D.C., of course, produces little except Political B.S., and I can't imagine anyone needing to order more of that...just turn on the TV!

Linq ;0)>

hmmm. they dont have a laughing emoticon?