|
 |
access thread: Combo box records
Message #1 by "Peter F Pennells" <ppenn@b...> on Tue, 28 Aug 2001 21:01:06 +0100
|
|
Hello
I have a form with a subform, the subform is based on a query which in turn
is based on the selection from a combo box.
The query works ok when a choice is made in the combo box - but what I want
to do is add a choice in the combo box that will show all records in the
subform.
Can anyone help please
Regards
Peter F Pennells
Message #2 by "peter pennells" <ppenn@b...> on Tue, 28 Aug 2001 21:13:46
|
|
Hello
I have a form with a subform, the subform is based on a query which in
turn is based on the selection from a combo box.
The query works ok when a choice is made in the combo box - but what I
want to do is add a choice in the combo box that will show all records in
the subform.
Can anyone help please
Regards
Peter F Pennells
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Tue, 28 Aug 2001 13:10:55 -0700
|
|
This and other bits of knowledge can be yours at Dev Ashish's Access Web.
8^) Check it out at:
http://www.mvps.org/access/
or more specifically:
http://www.mvps.org/access/forms/frm0043.htm
Cheers,
-Roy
-----Original Message-----
From: Peter F Pennells [mailto:ppenn@b...]
Sent: Tuesday, August 28, 2001 1:01 PM
To: Access
Subject: [access] Combo box records
Hello
I have a form with a subform, the subform is based on a query which in turn
is based on the selection from a combo box.
The query works ok when a choice is made in the combo box - but what I want
to do is add a choice in the combo box that will show all records in the
subform.
Can anyone help please
Regards
Peter F Pennells
Message #4 by "abed edammat" <edammat@y...> on Wed, 29 Aug 2001 09:46:02
|
|
> Hello
> I have a form with a subform, the subform is based on a query which in turn
> is based on the selection from a combo box.
> The query works ok when a choice is made in the combo box - but what I want
> to do is add a choice in the combo box that will show all records in the
> subform.
> Can anyone help please
> Regards
> Peter F Pennells
>
hi
first you have to create unbound combo box on the master form
let us to give it name as "mycombo" at the qurey you have to build acondition on
the bound column for ex. "mynumber" the condition must be at the critaria are of
this column as folows : forms![master form name]!mycombo
do not for get to make refrish on the combo event (after update)
|
|
|
View Cart
