[AccessD] Help with combo box

Borge

Thank you for your suggestion. I have made the changes you suggested. The 
only thing I will have to check with my client is whether the use of a 
scanner to input the movie will cause a problem with this setup. Other than 
that it seems to work great. I have set the recordsource for the text box 
as the combo box.

Thanks to everyone else who made suggestions. You have opened my eyes to 
more ways of looking for solutions.

David

At 12:25 AM 2/03/2006, you wrote:
>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
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com