to requery comboboxes in different two form link to a single data entry form

[ozzy]

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..?)

[pbaldy]

You could use error handling, but personally I'd use IsLoaded to test that the form is loaded before requerying.