Search results

Mstef - not what I am really looking for - although it works really nice. I should have mention in my post that I have to have my list box set to allow multi-select due to the number of distinct values - the master table is dynamically updated and the number of records could range from a...

MStef - Thanks for the reply and the suggestion. I will take a look at this and see if this will work for what I am trying to do. kenny

I am trying to figure how to do the following with a listbox On my Form I have a list box that shows my users a distinct list of items from a "master" table that they can select and add to their own user defined table that is used as a filter for a number of reports and queries As long as I...

oops.. forgot to indicate that it indeed resolved my problem. Again thanks kl

First – let me say thank you and most excellent suggestion :D Second – I took your suggestion and expanded it to be Dim ctlListBx As Control Set ctlListBx = Forms!frmMasterForm!lstDefaultWBS ctlListBx.Requery This way I can guarantee that I am updating the correct list box And...

Greetings to one and all I have a minor problem with a list box not updating that is driving me up the wall. Here is what I have I have a Form that has multiple pages (Tab control) and in one of the pages I have a list box that has row source of : SELECT DISTINCT temp_wbs.Wbs_Element_No FROM...

You have an extra single quote (') in your Call Line at the end of your path / file.. Call Shell ("D:\Telewest\TextFiles\IN\LO_DATA\DATTXT.bat"', 1) Should be: Call Shell ("D:\Telewest\TextFiles\IN\LO_DATA\DATTXT.bat", 1) Kenny[COLOR=orangered][COLOR=orangered]