A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

synchronize more than two combo boxes on a form in Access



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2008, 03:38 PM posted to microsoft.public.access.tablesdbdesign
Abbsy3
external usenet poster
 
Posts: 6
Default synchronize more than two combo boxes on a form in Access

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C
  #2  
Old May 22nd, 2008, 06:51 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default synchronize more than two combo boxes on a form in Access

Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos.
If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4
simple as that.
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C

  #3  
Old May 22nd, 2008, 07:22 PM posted to microsoft.public.access.tablesdbdesign
Abbsy3
external usenet poster
 
Posts: 6
Default synchronize more than two combo boxes on a form in Access

Hi,
Thanks for the quick response, but I am new to this, and only managed to do
waht I did having it layed out by the template. As I do not understand all
the ins and outs I still do not have much of a clue how to modify it, ie the
sql, does it need changing, do I need to modify the quirie? As like the
template used it uses 'lookup' into another table for each combobox.

Appologies for been a bit thick, and maybe Im trying to run before I can
walk, but I aint gor much choice, as my boss is expecting me to do this! All
help is very much appreciated.

Regards

Mark

"Klatuu" wrote:

Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos.
If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4
simple as that.
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C

  #4  
Old May 22nd, 2008, 07:40 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default synchronize more than two combo boxes on a form in Access

There are two basics.
Comb2 has to filter on the contents of Combo1. It can be one or more
columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1
in the Row Source query's WHERE Clause:

SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1;
(over simplified and absurd, but the basic idea.)

Now when you change the selection in Combo1, you need to Requery Combo2, so
you use the After Update event of Comb1:

Me.Combo2.Requery

Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even
exist.
That will keep you from getting confused about whether you need to consder it.

That is the whole concept in a nutshell.

By next week, you will be running track
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Hi,
Thanks for the quick response, but I am new to this, and only managed to do
waht I did having it layed out by the template. As I do not understand all
the ins and outs I still do not have much of a clue how to modify it, ie the
sql, does it need changing, do I need to modify the quirie? As like the
template used it uses 'lookup' into another table for each combobox.

Appologies for been a bit thick, and maybe Im trying to run before I can
walk, but I aint gor much choice, as my boss is expecting me to do this! All
help is very much appreciated.

Regards

Mark

"Klatuu" wrote:

Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos.
If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4
simple as that.
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C

  #5  
Old May 22nd, 2008, 07:52 PM posted to microsoft.public.access.tablesdbdesign
Abbsy3
external usenet poster
 
Posts: 6
Default synchronize more than two combo boxes on a form in Access

Thanks for laying out simple. Will give it a try at work tom. Thanks again!!!!

Mark

"Klatuu" wrote:

There are two basics.
Comb2 has to filter on the contents of Combo1. It can be one or more
columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1
in the Row Source query's WHERE Clause:

SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1;
(over simplified and absurd, but the basic idea.)

Now when you change the selection in Combo1, you need to Requery Combo2, so
you use the After Update event of Comb1:

Me.Combo2.Requery

Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even
exist.
That will keep you from getting confused about whether you need to consder it.

That is the whole concept in a nutshell.

By next week, you will be running track
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Hi,
Thanks for the quick response, but I am new to this, and only managed to do
waht I did having it layed out by the template. As I do not understand all
the ins and outs I still do not have much of a clue how to modify it, ie the
sql, does it need changing, do I need to modify the quirie? As like the
template used it uses 'lookup' into another table for each combobox.

Appologies for been a bit thick, and maybe Im trying to run before I can
walk, but I aint gor much choice, as my boss is expecting me to do this! All
help is very much appreciated.

Regards

Mark

"Klatuu" wrote:

Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos.
If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4
simple as that.
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C

  #6  
Old May 23rd, 2008, 07:59 AM posted to microsoft.public.access.tablesdbdesign
Abbsy3
external usenet poster
 
Posts: 6
Default synchronize more than two combo boxes on a form in Access

Hi Klatuu,

Your going to think Im completely useless, but I cant get it to work.
Basically I do not know what exactly to change / add from the template from
microsoft. I think I am doing some of it right, but just need to know the
exact changes. This is alot to ask, and would understand if you cannot give
me the time, as Im sure you have better things to do, and will just have to
keep trying. Let me know if you can help further.

Regards

Abbsy3

"Klatuu" wrote:

There are two basics.
Comb2 has to filter on the contents of Combo1. It can be one or more
columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1
in the Row Source query's WHERE Clause:

SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1;
(over simplified and absurd, but the basic idea.)

Now when you change the selection in Combo1, you need to Requery Combo2, so
you use the After Update event of Comb1:

Me.Combo2.Requery

Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even
exist.
That will keep you from getting confused about whether you need to consder it.

That is the whole concept in a nutshell.

By next week, you will be running track
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Hi,
Thanks for the quick response, but I am new to this, and only managed to do
waht I did having it layed out by the template. As I do not understand all
the ins and outs I still do not have much of a clue how to modify it, ie the
sql, does it need changing, do I need to modify the quirie? As like the
template used it uses 'lookup' into another table for each combobox.

Appologies for been a bit thick, and maybe Im trying to run before I can
walk, but I aint gor much choice, as my boss is expecting me to do this! All
help is very much appreciated.

Regards

Mark

"Klatuu" wrote:

Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos.
If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4
simple as that.
--
Dave Hargis, Microsoft Access MVP


"Abbsy3" wrote:

Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically
I want to do more! I am a bit of a newbie, so please excuse my lack of terms.
Basically using the form I mentioned it allows you to select data from one
combo box, and that data is filtered into the next one (dependant on what you
select in the first) what I want to do is have 4 combi box's with a 5th text
box resulting in a yes / no. Does anyone know if this is possible? Any
pointers in the right direction would be appreciated.
I do want to say, from what I have seen upto now, you guys do a great job on
this!!

Thanks

How to Synchronize two combo boxes on a form:

Link :
http://www.microsoft.com/downloads/d...8-78E549ECD14C

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.