Not able to select Drop-Down option on a Form (1 Viewer)

[SachAccess]

Hi,
I have a Form in my existing DB.
This form has a Combo-Box.
When I double click on the form and try to select drop-down option, I get a pop-up warning.
It gives me a path of Excel file and says, is not a valid path.
I am aware that, path is in-valid. I have corrected path available, but I do not know where exactly I need to change in-correct path with correct path.

I checked in form properties, data, nothing is there.
I checked properties of CB, in record source, we have a SQL query there.
Not able see the in-valid path mentioned anywhere. How do find where the path is mentioned in the form.

In short, am trying to find the entire old excel file in the (form) properties so I can change it.
Strangely, am not able to find that old path in the form.
Can anyone please help me in this.

Have a nice weekend!

 

[theDBguy]

Are you able to post a sample db to show the problem?

 

[SachAccess]

Are you able to post a sample db to show the problem?

Hi @theDBguy , thanks for the help. I am not allowed to upload anything, apologies.

PS - Will try to post a screenshot tomorrow. Have a nice weekend.

 

[bastanu]

Have you looked in the double-click event of whatever you double-click on the form (in the VBA editor)?

Cheers,