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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
update subform from value in another form
I have a mainform and two subforms liked through member number. I want to
enter data in the subform for every quarter for each member. I have an unbound combo box in the main form to select the quarter. How do I store the quarter information for each member in the subforms based on the combo box. I don’t want to store the quarter information in the main form. |
#2
|
|||
|
|||
update subform from value in another form
SeekAns -
It sounds like you are adding new records in the subform. If so, set the default value of the control in the subform to be the value selected in the combo box on the main form. -- Daryl S "SeekAns" wrote: I have a mainform and two subforms liked through member number. I want to enter data in the subform for every quarter for each member. I have an unbound combo box in the main form to select the quarter. How do I store the quarter information for each member in the subforms based on the combo box. I don’t want to store the quarter information in the main form. |
#3
|
|||
|
|||
update subform from value in another form
Than you. But How do I do that.
I went to the property section of the text box in my subform and in the default value propery I gave Forms![Main form name]![ComboboxName] . It is not working. Thanks for you help. "Daryl S" wrote: SeekAns - It sounds like you are adding new records in the subform. If so, set the default value of the control in the subform to be the value selected in the combo box on the main form. -- Daryl S "SeekAns" wrote: I have a mainform and two subforms liked through member number. I want to enter data in the subform for every quarter for each member. I have an unbound combo box in the main form to select the quarter. How do I store the quarter information for each member in the subforms based on the combo box. I don’t want to store the quarter information in the main form. |
Thread Tools | |
Display Modes | |
|
|