[AccessD] Continuous Form Issue

Jim Hewson JHewson at karta.com
Fri Sep 28 13:49:20 CDT 2007


Yes.

Jim 
jhewson at karta.com
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
Sent: Friday, September 28, 2007 1:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Continuous Form Issue

Are these bound combo boxes?

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
> Sent: Friday, September 28, 2007 2:19 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Continuous Form Issue
>
>
> Thanks... I tried it and it didn't work.
> I have also tried the following:
> 1.  after update event of the Option group to refresh the combo box
> 2.  on enter event of the Combo Box to refresh combo box
> 3.  put everything into one table with a filter on a field
> referencing the Option Group - using either 1 or 2 above
> 4.  used requery
> 5.  used repaint
> 6.  I've tried locking each one if it has a value but that really
> doesn't work... it locks the entire form
>
> What occurs after the refresh/requery/repaint the combo box drop
> down changes as required.... however, each combo box on each
> continuous form changes to what was clicked in the Option Group
> regardless of the Option Group on the form it resides.
>
> For example:
> Three "rows" (continuous forms [CF])
> 1 - HW
> 2 - SW
> 3 - HW
>
> If a new record (CF) is added the Option Group is clicked the
> previous CFs change to reflect the value.  In this case if SW
> option is chosen 1 and 3 above changes.
>
> Does that make sense?
>
> Jim
> jhewson at karta.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
> Sent: Friday, September 28, 2007 12:47 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Continuous Form Issue
>
> Do you mean the combo box recordsource should change based on the Option
> Group for that record?
>
> If so, then just change the recordsource on the On_Current event.
>  This will
> change it everytime someone changes records.
> Reuben Cummings
> GFC, LLC
> 812.523.1017
>
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
> > Sent: Friday, September 28, 2007 12:39 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Continuous Form Issue
> >
> >
> > A2003
> >
> > I have a bound continuous form that has an Option Group and a Combo Box.
> > What I would like to do is to update the Option Group and change the
> > rowsource of the Combo Box without changing the other records.
> > The purpose of the continuous form is to represent hardware and software
> > line items on a purchase order form.
> > The Option Group has two option buttons labeled HW and SW.
> > I need to change the rowsource using the option group buttons between
> > two different queries without changing the other combo boxes on the
> > continuous form.
> > Is this possible?
> >
> > MTIA
> >
> > Jim
> >
> >
> > --
> > 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
>
> --
> 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




More information about the AccessD mailing list