Solved Loop through using OpenArg on main form and 2 sub forms deep

[MajP]

I simply added a findfirst to the listbox afterupdate to move to the correct spec. I added an event on the forms oncurrent to selected the first choice . I tried this on the onload, that event often fails on a subform because the main form is not loaded yet.

 

[monk_1987]

That works an absolute treat!!! Seriously, thank you very much! The amount of time I spent trying to sort that out!

 

[MajP]

No problem. There is no way you could have explained that without providing a sample db, that form has a lot going on. Once I saw that the customer_ID did not belong, it made sense. I am guessing that is Welsh, and that made it pretty complicated to figure out.

 

[monk_1987]

Yeah, I was really struggling to find help on google because of it. I genuinely didn't think it was possible as nobody had seemed to ask it before. I'll post the answer in a bit to help other people who might have the same issue.

Yes it is Welsh. I'm impressed you knew! Not many people have heard of Wales, let alone the language. I still need to translate a lot of it. But want to get the structure in place before doing all that stuff.

Thanks again, stay safe!

 

[MajP]

I'm impressed you knew!

I would not be too impressed. It is not what you know, it is how good you are at Googling. Drop a word into Google and get this.

 

[MajP]

@Pat Hartman not sure of your point but both are completely legit for referencing a control
Resolve before hand
"[IDCONTACT] = " & FindIDCustomer
or have the query resolve
"[IDCONTACT]=forms![F_MainMenu]!FindIDCustomer"

Hower Me would fail in this case since the query would need a fully qualified reference.
"[IDCONTACT]=Me!FindIDCustomer" 'will not work

However, that was not related to the issue anyways.

 

[MajP]

Please read what I said again. I did NOT say that the reference to a control using Forms!formname!control name was not valid. I SAID that I made an ASSUMPTION (which is always dangerous) that the reverence was NOT to a control.

Well I found your post a little strange and confusing. Clearly in post 22# the OP was satisfied with the solution I provided, which was not related to anything in your post in thread #26. So I had to ASSUME you figured something was not correct. So was not really sure the purpose of the advice since the OP's syntax was correct initially.