Add Data to List Box

[shwin]

Hi everyone,

I have a problem which I haven't been able to correct with the help of the forums. I have browse button for the user to select a file. The file will be displayed as a hyperlink. I would like to create a button that adds this file hyperlink to a list box. I think I should use an append query but I am not sure. If anyone else has dont this before, your help would be appreciated!

Thanks!

 

[KenReay]

Hi

Depend if the lsit box is based on a query or table, if yes, then yes, an appnd query and requery the lsit box will do it, if it is a value list the you need to update the list, depending on version of Access you are using see .AddItem, or update the string of Values and requery the list box

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK