[AccessD] Help with combo box

David & Joanne Gould dajomigo at tpg.com.au
Tue Feb 28 00:33:08 CST 2006


Thanks for your prompt response Rocky.

At 05:11 PM 28/02/2006, you wrote:
>What event is the current code attached to?
>The database form is the Hiring form for a video library. There is 
>currently code attached to the "Before update" event, the "After Update" 
>event and the "On Double-click" event. The Double-click event allows the 
>user to add oir change the hiring code (overnight, weekly, etc).

>Can you use the 'Got Focus' event to run your new code?

The other issue I forgot to mention is it's on a continuous form. I have 
tried to make the combo box inactive if there is anything entered in it, 
but that just makes it inactive for all the records in the transaction (so 
I would only be able to enter one movie per sale).


>Rocky
>
>
>David & Joanne Gould wrote:
> > I have a combo box on a form that has quite a lot of code attached to it.
> >
> > Is there a way to run code when the user clicks on the drop-down arrow 
> that
> > won't interfere with other code that runs when the user double-clicks on
> > the combo box?
> >
> > TIA
> >
> > David
> >
> >
> >
>
>--
>Rocky Smolin
>Beach Access Software
>858-259-4334
>www.e-z-mrp.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list