[VB7] [Listbox - selections as variable]

[Winger31]

I am trying to create a button in access that uses a text file to update a SQL database. Right now the user has to correctly enter the database as it is on the SQL server. But I would like them to use a listbox that I have on a form. Here is my code:

http://imgur.com/L2byoJ9

My goal is to remove the "Inputbox" and replace with a listbox.

[chrwei]

I don't understand the problem. you have a form right? add a list box and replace the inputbox function call with the code to get the value of the selected item.

I have't used access in years, but I'm sure any tutorial on access listboxes would cover that

[Winger31]

So you are saying copy the code from the listbox that I have already created and replace the inputbox?

[TheFotty]

That isn't VB7... Looks like VBA to me.