[AccessD] Re-query 2nd combo on subform

Griffiths, Richard R.Griffiths at bury.gov.uk
Thu Apr 19 11:59:59 CDT 2007


I'll give it a try, thanks to all

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: 19 April 2007 16:54
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Re-query 2nd combo on subform

This is normal behavior in a continuous form with a combobox.  The way
I've always worked around it is to put a textbox behind the combobox and
make the backstyle of the combo transaparent.  Both controls are bound
to the same field, but when the record is not current, the value from
the textbox shows through.  When the combo gets the focus, the textbox
is automatically hidden.  Would that work for you?

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths,
Richard
Sent: Thursday, April 19, 2007 8:32 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Re-query 2nd combo on subform

Hi

Not sure if everyone's on the same track

Combo 1		Combo 2 (sub-activity)

A01				
B02
C03
D04

A01 has sub-activities SA01, SA02, SA03
B01 has sub-activities SB01, SB02, SB03
C01 has sub-activities SC01, SC02, SB03

Line 1 in sub (continuous form) select...

Combo 1		Combo 2  now shows (list)
A01			SA01, SA02, SA03


Line 2 in sub (continuous form) select...

Combo 1		Combo 2  now shows (list)
A01			SA01, SA02, SA03

All okay so far but.......

Line 3 in sub (continuous form) select B01...and

Combo 1		Combo 2  now shows (list)
B01			 we want SB01, SB02, SB03 to show in combo 2
(which I think does work) but on line 1 and line 2 the second combo
(whilst actually retaining the correct value behind the scenes now
displays a blank combo box value.  There is some logic here in that
combo 2 has just been re-queried using the filter main code B01 (combo
1) on the current line - the values in the combo 2 on lines 1 and 2
cannot now find/map correctly as there record source is using B01 as the
filter.




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Elizabeth.J.Doering at wellsfargo.com
Sent: 19 April 2007 16:01
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Re-query 2nd combo on subform

The only way I've ever hear of is to display the actual value in a text
box which is separate from the combo box.  Sometimes this can include
hiding most of the combo box most of the time.

Liz 


Liz Doering
elizabeth.j.doering at wellsfargo.com
612.667.2447


"This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation"

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Thursday, April 19, 2007 10:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Re-query 2nd combo on subform

I understand the issue Richard, but sad to say have never found a
satisfactory solution. If I understand you right it's when the field
stored by combo2 is not the one displayed, typically the bound column is
the 1st column with a zero width. Is that right? So as soon as you
requery the combo then most records on the subform find themselves
trying to display something which is no longer in the combo's recordset
as it were. I'll be watching with interest for good ideas.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Re-query 2nd combo on subform
Date: 19/04/07 14:08


Yes combo 2 has a query source that references combo 1 e.g. combo 1 -
Activity Code... Combo 2 sub-Activity Code

When you select Activity code you want combo 2 to list all
sub-activities for that main activity code



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: 19 April 2007 13:41
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Re-query 2nd combo on subform

In the After Update event of Combo1 are you requerying Combo2? What's
the row source for Combo2? Does it include the value of Combo1?

Rocky








-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths,
Richard
Sent: Thursday, April 19, 2007 3:50 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Re-query 2nd combo on subform

Hi

Access 97

It's been a long time since I've posted here - still take a regular
look, even though I concentrate on .net these days.
A combination of time without Access and lack of time to play around
myself..... but I have someone asking my advice.

Scenario.....timesheet screen...

header record with continuous subform details.
Two combo's on the subform....the second of which needs to be re-queried
based on the value in combo 1.
This is actioned on the after-update event of combo1.

The undesired result is that on previous records in the subform combo 2
is cleared out when combo 1 is re-queried (if the list id different say
to the current record).

I'm sure I've been here before......but can't get the solution...so all
you active MS Accessers..... any clues??

Thanks in advance


Richard Griffiths
0161 253 5169
Software Developer


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.2/766 - Release Date: 4/18/2007
7:39 AM


--
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

________________________________________________
Message sent using UebiMiau 2.7.2

--
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