Hello,

I'm a new user of Axure and new to this site. I searched for an answer, but I couldn't find anything similar to my problem. I'd like to be able to modify the values that appear in a list box using buttons. I have a page with the following widgets:

New Value text field
List of Values list box
Add button
Remove button

I want to type a value into the New Value text field, click the Add button, and have the new value appear in the List of Values list box. Similarly, I want to be able to select a value in the List of Values list box, click the Remove button, and have the value disappear from the list.

Is there any way to do this dynamically or is my best bet to just make some mock-up panels to simulate this functionality for my customers?

Thanks in advance.

Brie

Hi Brie,

Thanks for the post. There isn't a way to do this dynamically. Using a dynamic panel with some sample scenarios is the best way to show this today. We're considering adding the ability to dynamically set the options in a list.

Hi, I'm also a beginner in Ms Access. Due to my limitation on VBA coding, I can only help u to resolve the "add value" part to list box.For "remove value" part, I still don't know what code to use. Perhaps you can help me?

Basically, there are three ways as follows:-

1. You can add/remove value into list box freely. However, it doesn't bound to table/queries. You can refer to this site for futher info http://www.599cd.com/tips/access/listbox-additem-2000/

2. You can add/remove value into bound list box(bound to table/queries) by create a command button(add value). The function of this button is to open another form that contain  bound text box(for you to type your new value here). Then create another two buttons: "ok" & "cancel". The trick is when you click "ok" button. It close the form and at the same time requery the list box value.

3.Finally, last method is the most easy way and most similar to your question. You'll need to create bound table and bound text box. Then, you create "add value" command button. The trick is on the "on click" property  of "add value" command button. You need to put requery coding.

That's all I can help you

For the 2nd way, you need this code  at "on click"  for "ok" button:-

Private Sub cmdOk_Click()
On Error GoTo Err_cmdOk_Click

    DoCmd.Close
   Forms![Form1]!List0.Requery
Exit_cmdOk_Click:
    Exit Sub

Err_Command2_Click:
    MsgBox Err.Description
    Resume Exit_cmdOk_Click
   
End Sub

For the last method, you need to put this code at "on click" for "add value" command button:-

Private Sub Command9_Click()
On Error GoTo Err_Command9_Click

    DoCmd.GoToRecord , , acNewRec
    Me.Form!List2.Requery
Exit_Command9_Click:
    Exit Sub

Err_Command9_Click:
    MsgBox Err.Description
    Resume Exit_Command9_Click

End Sub

 

All the best to you! Hope you can reply me a.s.a.p on how it works!!!!

Hi Simon, thanks for the post. To clarify... this is a forum for Axure RP (and not MS Access).

Oops, sorry!!! I don't even know its not Ms Access. Anyway, thx for your reminder.

Have you decided to include dynamic lists in an upcoming release?

 

Thanks

Hi Liz G, we know we want to add the actions to enable this, just not sure which release yet.

Hi Liz G, we know we want to add the actions for this, but just not sure what release yet.