Combo Box Selection

[IleanaH]

I am using a form with combo box selection menu. Sample Selections are ie:
Paper,Envelopes,Toner,Pouches . When the selection is made is filters and
opens a new form based on selection criteria. But after this process is
completed. I return to the Selection Menu and exit. Upon exiting the last
selection made changes the selection in the combo box.

Example : Selection made is "Envelopes" Envelopes becomes the first and
second selection replacing "Paper" in the Combo box List.

This is a stand alone query/Table.

This code for the form filter

Dim stLinkCriteria As String
stDocName = "frmCategoryFormList"
stLinkCriteria = "[CategoryName]=" & "'" & Me![CategoryName] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

What am I doing wrong.

 

[Dorian]

You dont tell us what is happening?
I'd display the value of your filter to make sure its set up right..

stLinkCriteria = "[CategoryName]=" & "'" & Me![CategoryName] & "'"
Msgbox stLinkCriteria
DoCmd.OpenForm stDocName, , , stLinkCriteria
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".