Parameter keeping the last input value.

[ciarra41]

How could I have a parameter query save the last value or values I enter until I change them.

SELECT DISTINCT
FROM Maxtbl
WHERE (((InStr("," & [Enter Comma for separated SKUS ] & ",","," & [Maxtbl.SKUS] & ","))>0));

 

[AlexCuse]

You can take the parameter value from a form control perhaps?

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[traingamer]

And have the form control based on a table of values which would then persist from session to session.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill