Combo Box Help

[DavidW]

How do you get another forms combobox to change(if thats the right word)
I have got one form ,and when a certain condition is meet, it opens another
from
what I am trying to do is to take text229's value from the first form and
put in the second forms combo40 to load the forms subform.
I can get the value in the second forms combobox, but how do you make it
update(combobox) so the subform will update
Thanks
Dave

 

[Howard Brody]

Try populating the ComboBox and then requerying the
subform:

Dim strValue As String
strValue = [text229]
DoCmd.OpenForm "frmSecondForm", acNormal
[Forms]![frmSecondForm]![combo40]=strValue
[Forms]![frmSecondForm]![sbfSubForm].Requery

I try to rename my controls, too, so it's easier to
remember what they are - for example: txtInvoiceDate vs.
Text14.

Hope this helps!

Howard Brody

 

[DavidW]

No That didnt do it, do appreciate the effort though

Try populating the ComboBox and then requerying the
subform:

Dim strValue As String
strValue = [text229]
DoCmd.OpenForm "frmSecondForm", acNormal
[Forms]![frmSecondForm]![combo40]=strValue
[Forms]![frmSecondForm]![sbfSubForm].Requery

I try to rename my controls, too, so it's easier to
remember what they are - for example: txtInvoiceDate vs.
Text14.

Hope this helps!

Howard Brody

-----Original Message-----
How do you get another forms combobox to change(if thats the right word)
I have got one form ,and when a certain condition is meet, it opens another
from
what I am trying to do is to take text229's value from the first form and
put in the second forms combo40 to load the forms subform.
I can get the value in the second forms combobox, but how do you make it
update(combobox) so the subform will update
Thanks
Dave


.

 

[Debra]

It's called synchronizing combo boxes. One of these two
links should get you started.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;209595&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-
us;209576&Product=acc2000