Rather than using a local or network connected database for a set of options in a drop down I would rather use a list of options on a webserver.

The list could be in an XML file, DB, whatever.

Anyone have any ideas or sample code.

Thanks,

You can download any file using this simple code:

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Private Sub Command1_Click()
URLDownloadToFile 0, "http://www.yoursite.com/yourfile.txt", App.Path & "\" & "yourfile.txt", 0, 0
End Sub

The first param is the URL and file to download and the second param is where you want to save it to.

Edited February 18, 200719 yr by pcuser_tom