"how can I retain the users input" regardless on closing of the form

[chacamasur]

I have a combo box on a FORM that is currently linked to a table/pulldown for selection: sort, column1, column2

I have set up the combo box to show Column1, and have a set an invisible textbox that grabs the sort value.

I am using the text Box within a Query criteria:

>=[Forms]![FRM-EstCAD]![RPsort]


---> right now the value on the form disappears when the form is closed.
The question is: "How can I retain the users input" regardless on the closing of the form?

 

[ghudson]

You need to store the value in a table if you want to retrieve it even after the database is closed.

 

[chacamasur]

Yes... table (not sure is is what I am looking for) but if you could explain a little more: I am not sure if I am thinking the right way (lol)

Figured:


Cbox - select 150 combo box is looking at a list where I don't want to add or change the list table.
form closes --> reopens and 150 is there.





this user input .. how would we get it into a table...

 

[chacamasur]

guess how do I store it in a table if that combox is pointing to another table that I don't want to update.