[AccessD] Continuous Form Issue

Jim Hewson JHewson at karta.com
Fri Sep 28 13:48:56 CDT 2007


That didn't work.  It changed all the combo boxes at the same time.

Jim 
jhewson at karta.com
 

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

Jim,
In the option group using the onclick put this (Aircode).  Assuming the
option values are 1,2,3 etc

Select case <nameofoptiongroupcontrol> 
Case 1
Me!cboboxname.rowsource = "select * from tblHardware"
Case 2
Me!cboboxname.rowsource = "select * from tblSoftware"
Case else
' keep putting your options here
End select
Me!cboboxname.requery


MAx


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Friday, September 28, 2007 7: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