Run-time error all of a sudden

[matey56]

Hi,
I have a form that is giving me a run-time error after making a small change. It's an Access form with a SQL backend. The form is a single form with a subform (one to many relationship). I use an unbound box in the main form to select a product and requery the subform which gives me multiple hits.

Literally all I did was add a new field to the table in SQL, refresh the table link in Access, add the new field to the subform and save it. Now when I open the main form and select a product I get this error:



I didn't touch the VB script at all. When I click Debug it highlights the subform. Any idea why I'm receiving this?

[Welshgasman]

You are not showing anything.
You cannot copy and paste images on this site, you need to attach them as files.

[ranman256]

windows & office can run updates and mess with internal references.

[Bulzie]

Open just the subform, does it work with no errors and do you see the new field in that form? Add some data to the tables so you can see it in the subform. This could tell you if there is an issue with the subform or not.

Need to see the error

[matey56]

You are not showing anything.
You cannot copy and paste images on this site, you need to attach them as files.

Can you see the attachments now?

[matey56]

Open just the subform, does it work with no errors and do you see the new field in that form? Add some data to the tables so you can see it in the subform. This could tell you if there is an issue with the subform or not.

Need to see the error

The subform is fine. It's definitely something with the main form. It's just weird because I didn't change anything in the main form.

[Welshgasman]

That is the subform control name?

[matey56]

That is the subform control name?

It is. I can click End or Debug and go on about my business and everything works fine. It only happens when I first open the form.

[moke123]

It only happens when I first open the form.

Do you have option explicit declared?
does the code compile?

Any code in the open or current events?

[Bulzie]

Maybe try full path of subform? (adjust syntax)
Forms![mfrmxxx]![sfrm_Supplemental_Distributor_Products].Requery

Could also look to use Linkchild, Linkmaster on subform Data properties to link the subform, then you would not need to do the requery on the subform.