[AccessD] Help with combo box

Haven't been following this thread, so I am just jumping in...
I would do something like:

Create cboRental and adjust the width so only the down arrow displays
Create txtRental; make it enabled and locked and place it to the left of
cboRental so it looks like one control.
On afterupdate of cboRental push the field that normally would display in the
combo into txtRental.
Do your double clicking code on txtRental; single clicking on the cboRental...

would that do?

regards
borge


----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 01, 2006 2:19 PM
Subject: Re: [AccessD] Help with combo box


> David:
>
> AFAIK, no, the down arrow is not a separately programmable part of the
> control. But AFAIK may not go all that far.
>
> Rocky
>
>
> David & Joanne Gould wrote:
> > Rocky
> >
> > The Double-click event is set to open another form to change the Rental
> > Type for this movie title. What I was wondering was if there was a way to
> > access the drop-down arrow on the combo box as a separate thing. This might
> > separate the main part of the control where all the other code is
> > connected. Can it be done?
> >
> > TIA
> >
> > David
> >
> > At 01:18 PM 1/03/2006, you wrote:
> >
> >> Sorry about the late response.  I was out all day.  Can you use the
> >> click event?  What additional function are you trying to implement?
> >>
> >> Rocky
> >>
> >>
> >> David & Joanne Gould wrote:
> >>
> >>> 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
> >>>>
> >>>>
> >>>
> >>>
> >> --
> >> 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
> >>
> >
> >
> >
>
> -- 
> 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