Hello,
My problem is to requery comboboxes in different two form link to a single data entry form. to be specific;
I have two forms and two comboboxes in them and next to comboboxes i placed buttons to open data entry form
FrmComponentsDataEntry
-> cboReusability
-> btnReusability
FrmEquipmentDataEntry
-> cboReusabilityEquipment
-> btnReusabilityEquipment
these comboboxes are feed from same form "FrmReXabilityDataEntry" . I used this code to requery combobox after adding new record to "FrmReXabilityDataEntry" for the first form "FrmComponentsDataEntry".
Private Sub Form_Close()
Forms!FrmComponentsDataEntry.[cboReusability].Requery
End Sub
to requery second form i added this code under
Forms!FrmEquipmentDataEntry.[cboReusabilityEquipment].Requery
but when i edit in second form macro gives error naturally and says access cannot find FrmComponentsDataEntry , because first form is not open.
What kind of code should i use? so that macro requery only comboboxes in open form. FYI i am not good at coding yet
(actually code requery the fileds but may be i should use error handling or smth..?)