Combo Box Help

  • Thread starter Thread starter DavidW
  • Start date Start date
D

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
 
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
 
No That didnt do it, do appreciate the effort though
Howard Brody said:
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


.
Click to expand...
Click to expand...
 
Back
Top