Forms programming

  • Thread starter Thread starter John Allen
  • Start date Start date
J

John Allen

1)How do you change a combo box from unbound field to
bound field?
2) I have 3 forms and 3 macros inwhich the first form
has a combo box that contains a list of dates from
which the user can choose. When that is selected it calls
a macro that displays a form with a combo box that
displays a list of member names. When the user selects
the name then a macro displays another form for the user
to fill in fields. The macro is using SetValue twice to
fill in the Date and member name previously selected.
However, it appears that even though the forms are still
open the values selected are not really updated in the
form. I guess my real question is? if you double click on
an item in the drop down list and it moves to the field
box, is there some other action (event) required such
that it is really "saved" so other forms/macros can use
this value.

Thanks
 
1)How do you change a combo box from unbound field to
bound field?
Click to expand...

Set its Control Source property to the name of the field to which you
wish it bound.
2) I have 3 forms and 3 macros inwhich the first form
has a combo box that contains a list of dates from
which the user can choose. When that is selected it calls
a macro that displays a form with a combo box that
displays a list of member names. When the user selects
the name then a macro displays another form for the user
to fill in fields. The macro is using SetValue twice to
fill in the Date and member name previously selected.
However, it appears that even though the forms are still
open the values selected are not really updated in the
form. I guess my real question is? if you double click on
an item in the drop down list and it moves to the field
box, is there some other action (event) required such
that it is really "saved" so other forms/macros can use
this value.
Click to expand...

Without knowing more about the steps of the macro I'm not sure even
what you're asking. The Value of a combo box control is the value in
the bound column of the record which has been selected, so long as the
Form containing the combo box is open.

It looks to me like you're going to a LOT of extra work using all
these forms and macros! Could you explain the task you're trying to
accomplish? I'm suspecting there are much easier ways to do it!
 
Back
Top