Reuben Cummings
reuben at gfconsultants.com
Fri Sep 28 14:10:37 CDT 2007
So the SW and HW options are stored in two different tables? Are the "ID's" in these two tables the same? For example,... HW Item HW ID HW 1 1 HW 2 2 HW 3 3 SW Item SW ID SW 1 1 SW 2 2 SW 3 3 If this is roughly the case then as the combo's change it is seeing the new idea from the wrong table and returns the item from the wrong table. If the ID of HW 1 is stored (1) then when the rowsource is changed to match the SW option the rowsource now runs using 1 as the ID which returns SW 1 because you changed tables, but are still using 1 as the ID to search on. Changing rowsources on a combo on a continuos form is tricky if you are trying to change completely what you are showing. I think you will always have a problem of some sort with this. I think even if you get it to NOT show the "wrong" item it may very well be blank if the current record is the other type. What I mean is if you select SW then the HW combos may be blank at best. Combos on a continous form are tricky. Cany you use a "static" continuous form that only "shows" the selections and allow a double-click (or other) starting option that gets the user to entry portion? This way you could use queries to put the correct description with the correct ID number based on the Type selected. The form would show SW SW2 SW SW3 HW HW1 , for example But these would all be listed in text boxes because you have already set the text correctly. A double click on the type field would pop up a form to edit this record or add a new record. Your combo changing would be eliminated because you are only showing one record at a time on the add/edit form. I'll be back Monday to help out if I can. 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:49 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Continuous Form Issue > > > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >