Search results

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.

We dont know which the form name called formC... since formC is opened from combobox. And my topic goal is to know this form name... Does it require extra work from user? User must to enter a wrong item to trigger NotInList event?

Hi Nifty Therefore the code fails and causes an error when you try to re-query the combo box on a closed form. -->Yes, this is the keypoint of my issue. 1) All of these forms and subforms are within one MS Access front end database used by one person? - One FE, one person 2) you can have many...

Hi Nifty, Thank for making the video, I have learnt alot from your youtube channel. My concern is in the case we have many form + subform (for example FormB1 - subformA1, FormB2 - subformA2...) what employ same combobox Cbx_Footprint. So, in the AfterUpdate event of frmFootprint, how do you...

Hi The Combobox_Click event does not fire when you click on "Edit List Item" of combobox, thus I still can't configure out how to pass the argument "Me.Name" to formC. So, formC does not know how it was opened. This is my problem.

Hi Moke It works in case formA, formB is standalone. In fact, my formA is a subform then the code CurrentProject.AllForms("FormA").isloaded always returns False. Furthermore, It is a bit manually, if later I have formA1, formA2 with same scenario, I will have to add these code again... what I...

Hi Mike That is a working solution. However, formA has servaral Combobox and we rarely edit items on formC thus I personally dont want many redundant requery action of these Comboboxes. (Form may be flashing on requery action as well)

Dear all I have formA and formB that both contain combobox Cbx_Footprint. User can click on "Edit item list" to open other form (formC) for adding new Items. When closing formC, I would like to requery Cbx_Footprint to have latest Items likely: Forms!FormA.Cbx_Footprint.requery However I dont...

Sorry, my typo, I was meaning "duplicate textbox". I have just done my code with your idea, it works as expected.