Two multiple combo boxes values depend on each other (1 Viewer)

[AsMok]

Hi all
it is long time since my last log in
nice new ACCESSWORLD view ...i like it
-----

my question is ....I have two multiple combo boxes

the first is for people who we invite for specific meeting (not all attend sometimes)

the second is for people who actually attend the meeting later

i have a table for "lets say" 100 names
for the first combo box (gusts) it is ok to choose from this 100 names table because no rule set which will be invited...

but the second combo box (attendance) will be be restricted to the choices from the first combo box

how can i do make attendance combo box values depends on the gusts ones on each record????

 

[MajP]

Not totally clear. Search this thread for the term cascading comboboxes. But I am not sure that is what you are asking. I read this that you want a multi select listbox where you can select everyone to invite. This populates listbox 2 where you can select those that attended. I have code to do that, but not sure once you select the attended where you save the information.

 

[MajP]

If the cascading combobox is not what you want, come back and describe it better so we can help.

 

[AsMok]

If the cascading combobox is not what you want, come back and describe it better so we can help.

HI
honestly i did not have time to try
and now I have another point regarding compo box
so i am preparing a mock db to share that makes the issue clearer

thanks in advance

 

[MajP]

That would help

 

[AsMok]

Addition::

I solved my first question by a query that makes the names that appear in the gusts and attendances compo boxes only for the group members.......you can find that in the attached db....

NOW?

how can i add "select all" choice to my multiple compo box choices? sometimes all members are invited other times only some ones......

BTW I am a new user of access and do not know a lot about coding and programming ^_^

a cannot upload it it keeps giving me this message --The uploaded file does not have an allowed extension. -- i tried to upload an access file and a .rar file

 

[vba_php]

i tried to upload an access file and a .rar file

if I'm not mistaken, both MDBs and ACCDB files are allowed here. I don't think RARs are, but I know that ZIPs are. don't you have WINZIP? It comes pre-installed with all windows OSs I think.

 

[MajP]

Private Sub CmdSelect_Click()
 SelectUnselect
End Sub


Private Sub cmdUnSelect_Click()
 SelectUnselect False
End Sub
Private Sub SelectUnselect(Optional SelectAll As Boolean = True)
  'False to unselect
  Dim lstItem As Integer
  Dim lst As Access.ListBox
  Set lst = Me.ListMulti
  For lstItem = lst.ListCount - 1 To 0 Step -1
    lst.Selected(lstItem) = SelectAll
  Next lstItem
End Sub

 

[zeroaccess]

if I'm not mistaken, both MDBs and ACCDB files are allowed here. I don't think RARs are, but I know that ZIPs are. don't you have WINZIP? It comes pre-installed with all windows OSs I think.

Not exactly WinZip, but the functionality is built-in these days: select from the right-click context menu "Send to -> Compressed (zipped) folder"

 

[zeroaccess]

Hi all
it is long time since my last log in
nice new ACCESSWORLD view ...i like it
-----

my question is ....I have two multiple combo boxes

the first is for people who we invite for specific meeting (not all attend sometimes)

the second is for people who actually attend the meeting later

i have a table for "lets say" 100 names
for the first combo box (gusts) it is ok to choose from this 100 names table because no rule set which will be invited...

but the second combo box (attendance) will be be restricted to the choices from the first combo box

how can i do make attendance combo box values depends on the gusts ones on each record????

It also depends on whether you are trying to do this on a form's detail area or in a subform. If in a subform, it gets complicated.

 

[MajP]

Demo

 

[AsMok]

I want to add select all to gusts and attendance fields

 

[AsMok]

 

[MajP]

Noone is going to bite on this one. That is a multivalued field. These are very unpopular, and what you are asking cannot be done. People will recommend that you get rid of the multivalue field.

 

[AsMok]

the following code from this site is working great for selecting all values if my row source is a table.... what should i change to change it to a query...

-----

Dim v As Variant
Dim vValueList As Variant
Dim rstAdd As DAO.Recordset
Dim rstLookupValues As DAO.Recordset

vValueList = Split(Me.FavColors.RowSource, ";")

' delete any possbile selected records...
Set rstAdd = Me.Recordset!MyColors.Value
Do While rstAdd.EOF = False
rstAdd.Delete
rstAdd.MoveNext
Loop

' now add all
Me.Recordset.Edit
Set rstAdd = Me.Recordset!MyColors.Value
Set rstLookupValues = CurrentDb.OpenRecordset("tblColors")
Do While rstLookupValues.EOF = False
rstAdd.AddNew
rstAdd(0) = rstLookupValues!ID
rstAdd.Update
rstLookupValues.MoveNext
Loop
Me.Recordset.Update

rstLookupValues.Close

 

[MajP]

Hopefully someone will help, but it is unlikely. Most people are against using MVF and I am not going to help some one because it will just cause bigger problems. I use my own custom class, but works on true normalized databases.

 

[AsMok]

​

 

[AsMok]

Demo

Hi many thanks ​

I used your code.....

1. i just changed my control type to list box instead of combo box on the form and kept the table field a combo box ......
2. and replaced my control name in your code ^_^

then it works as you can see

Any suggestions not to face any future problem????
​

 

[AsMok]

DONE
any suggestions