Easiest way to "save" a value on a form..

[snipe]

Hey guys,



I have a form that I just added a new unbound text box to designate a search criteria, its just a number value. The search is ran, and data is pushed into some tables. When the form is closed, the number that was entered into this text box disappears. The user won't know what the criteria was when the data was ran.

What is the easiest way to keep this value stored after the form/program is closed and reopened?

[orange]

You could put it in a table that shows who, when and the number. You could have a query to show that user what the last number used was.

Just a few thoughts. We relly don't know the significance of the number.

If you're doing a search using that number, where and how is

other data being pushed into other tables?

There must be some other process(es) being spawned in the code.

[snipe]

I just mentioned the super simplified version.

The criteria is any sale that was made where the "warranty-able" merchandise value is over the number specified in the text box.

There are ton of other processes that fire. 17 append queries that go to 6 different tables. Reports are the generated as the user desires.

I made a new table with 1 field and 1 record and linked that text box to that field (after linking the table to the form). It isn't saving.

How can I write all sorts of VBA and design queries yet I can't figure this out? I feel like an imbecile haha.

[orange]

We've all been through it. You're too close to the problem -- is the usual symptom.

Regarding your new table - Is the number involved specific to a particular User or Client or Product...

Do you have to record the number and date and User... for each time that process is executed?
I'm not picking up the context of the number --who , when, why it's used...

[snipe]

Ok wow. I just fixed that little brain fart. The query that this new criteria goes into is an append query. I just added an extra field to that table and used the criteria in it. The fields default value pulls from that new field. Problem solved. Sorry to waste your time!

Happy hour is calling my name!

[orange]

Remember it's a sober second thought....
Glad you have it resolved.