I have updated the controls in Form “A” then I update the form, I then want to update the controls in Form “B”. I have added the code in Form “A” After Update, “Forms![F_Search Parts]![Combo10].Requery” and this updates Form “B” controls OK, providing Form “B” is open. If Form “B” is not open I receive the error message “Access can not find the form [F_Search Parts] referred to in the macro or visual basic”. I add in the Event Before Update of Form “A” to open Form “B”, this works great, except Form “B” opens on top of Form “A”. Is there a way to update the controls in Form “B” without opening Form “B” or if I have to open Form “B”, it does not open on top of Form “A”.
I would appreciate any assistance.
kevsim
I would appreciate any assistance.
kevsim