Re: Query's in VB code

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Larry Linson (bouncer_at_localhost.not)
Date: 04/22/04 

Date: Wed, 21 Apr 2004 21:39:29 -0500

Where did you put the code?

If you are going to use the selected value from the list box, I see no
alternative to actually selecting the listbox. You could specifiy a default
value for the list box, and use that value, perhaps.

If you put the code in the Click or AfterUpdate event of the ListBox, then
the event will have to fire for the code to execute. When do you _want_ or
_expect_ the code to execute.

  Larry Linson
  Microsoft Access MVP
"Brandon Brewer" <anonymous@discussions.microsoft.com> wrote in message
news:4297FC4B-14DB-4965-808B-57A47B6196B9@microsoft.com...
> I got it working except that I have to click on the list box is there an
automatic way to do this
>
> I have tried to setfocus select object but I dont know what the object
would be called listBox
>
> If I dont select the list box it doesnt recognize the field says it is
empty
>

Relevant Pages

  • Re: How to do file association through java????
    ... searching a perticular ... file i m selecting that file to open or execute. ... But i dont know how ...
    (comp.lang.java.help)
  • ListIndex problems,
    ... i dont know why it is not ... selecting the same row in list box 101 as in listbox 102 ... Sub Item_CustomPropertyChange ...
    (microsoft.public.outlook.program_vba)
  • Re: Cant Figure Out How to Access a List Item
    ... For the default property, open the CMessages class file, and put your cursor on ... Public Property Get ItemAs CMessage ... listbox Procedure ID in the middle, ... Change the Procedure ID to by selecting it in the listbox. ...
    (comp.lang.basic.visual.misc)
  • help with common dialog for multiple file insert please
    ... I wrote some code to let me select multiple files, ... For the common dialog stuff I used the code kindly ... the first entry in the listbox is the ... entry and the second as the file name even when only selecting ...
    (microsoft.public.word.vba.general)
  • RE: Report via List Box
    ... If the users are not selecting the records in the listbox then you are ... Microsoft Access Support ... Microsoft Security Bulletin MS03-026? ...
    (microsoft.public.access.macros)