Simple Problem I'm sure, but I don't know

[HowardChr]

I am trying to create a simple working program in Access. I have a List which has pulled information from a tabel. I am trying to set up a command button to understand which option I chose in my list and open a corresponding form. I tried to enter:

DoCmd.OpenForm "Store Walk", , , "[100] = " & CLng(Me.List1.Column(0)), acFormEdit

And this works, however no-matter which option I choose, It opens the form Store Walk. Any ideas would be MUCH appriciated.

 

[rainman89]

its opening the form store walk because u are telling it to here
DoCmd.OpenForm "Store Walk"
do you mean its not opening to the record that u have selected?

 

[HowardChr]

Exactly. I am trying to have it open the form that I choose from a list. Example:

List shows options: A, B, C
If A is selected, and then Submit is pressed, I want Form 1 to open;
If B is selected, and then Submit is pressed, I want Form 2 to open;
If C is selected, and then Submit is pressed, I want Form 3 to open;

 

[rainman89]

ok then

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = Me.List0
    DoCmd.OpenForm stDocName, , ,

 

[HowardChr]

MANY thanks!