Combo Boxes

[kathyrich1]

I have 4 combo boxes on my forms that are bound to the table the form is built on. Problem... I need the combo boxes to keep the data selected and not clear when the user tabs through the records. Also, I need the data to stay until user selects something else in the list, even after the form has been closed and re-opened. I have tried SQL query, but the boxes clear as soon as the user tabs to another record. If I use unbound fields, the data is gone the next time the form is opened. It is not necessary for the data to be tied to a field in the table, I can pull it in a report, or even export to another table. I can not figure out how to get this result. I have tried separate tables and queries to no avail. Can someone help?

 

[braindead2]

Use combos but set the default to what ever you want it to be

 

[kathyrich1]

The data is user defined. It will not have a default value. Any more suggestions?

 

[cfillis]

Think I may have encountered something similar. Here's how I got around it: Create a seperate database with a temporary table that uses lookups linked to my primary database table(s). This way the values entered by the user are limited to the values in my primary tables, but can be stored and brought up anytime by each user. I used this as a way to allow multiple users to each have unique situations on our network. The downside is that you have to install the new database on each users local PC, and any form updates must also be done manually, but the structure of my tables is static enough to keep it managable.
Hope this helps.
cf

 

[HOMMER]

Kathyrich1,
I am trying to do the same thing. Did you ever get this to work? If you did please let me know how.


Thanks

 

[rajeessh]

For bound values of Form u need to have that for that record
So during Form_Current
If NewRecord Then
-- Lokkup your values and aset the combo boxes
End if

Try lookup from The Fields in table in case of Unbound
Form_Open

Lookup the Fields and set to the ComboBoxes.


Try this and get back if worked Sirs?