Search results

Hi CJ_London Since you are running on A10, could you please do me a favor by making accde file from accdb file on post #1 and upload the file here. I will download it and run on my A365 to see the result... Thank you

Hi DocMan The reference list is same for both

Hi jdraw. How did you build sampledb.accde? Did you build it from Access 365 (Version 2307 - Build 16.0.16626.20134 64-bit)? If so, then yes, it should work. I built it from Access10 and it got error when running on Access 365. I attached the accde file what built from Access 10...

Hi Everyone I have a Access project (Sampledb.accdb) on my PC win10 - Office365 (64bits) A virtual machine (on same PC) i have win10 Office10 (Pro-64 bits) On my PC: -Run accdb: Working well On Virtual Machine (win10 Office10): -Run accdb: Working well -Save as...

In fact, many proposed solutions. I was also missed Edgar solution about using OpenArgs until he makes "clearly nice pictures" to point out what I missed, his solution make me learn new things. May you also elaborate your proposed solution, so that I and other new member can learn it then?

Yes, definitely. I use OpenArgs quite often, but i have to set its value manually. I thought it was blank if we dont touch it...

Hi The Doc Man @mike60smart has reccomended similar solutions which works. My issue was solved right away on his post #2. But then I am trying to find better solution which only do requery when neccessary, and end-up with the new goal of how to know which form open which form. Thank you very...

@Edgar. Yeah, sorry again, I was not testing out your suggestions. I am surprise the formC OpenArg telling us about the form opened it. Glad to clearly distinguish formA and formB in its openarg Thank you very much again.

I dont know why it is not working at my side. Seem Edgar can replicate the issue. Sorry about bad sample db, it not what my real project. I just want to make a demo the issue.. How is about your db, Nifty? can you remove the button "Edit combo list" and open formC from combobox?

Hi CJ Really sorry for that, I have tried to understand your suggestion but I was not sure i understand it hence I dont know how to implement it

Post #2, #4 we have discussed about it

No event, so cant set tempvar

I attached the sample db here, for easy evaluate the issue

It opens by clicking on "Edit List Item" of combobox.... I dont see where to add the code

I not opening formC from command_button thus now where to add this code

I need to know the calling form to requery the combo on it.

It is 2nd problem, I dont know which form opened it (formC)?

Yes, it is exactly what i want.

No, user will not type in anything, they use mouse to select an existing item, if the desired item is NOT existed, they will click on "Edit List Item" to open formC. After they adding new item (called ItemX) on formC, they close formC and back to combobox, at this time the combobox should have...

Hi CJ_London FormC (frmFootprint) is opened from combobox Cbx_Footprint as below screenshot.