Reuben Cummings
reuben at gfconsultants.com
Fri Sep 28 12:47:08 CDT 2007
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 >