Search results

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.

I have a standalone form with buttons on footer section. I would like to use it as subform too. So when it plays role of subform, these buttons will be move up to its header. it becauses the mainform already has some buttons at bottom of screen while I dont want many button at screen bottom. I...

Dear all Can anyone help to move control Txt_ID from Header to Footer section with VBA code of button Btn_MoveCtrl? I tried with Move method but it is only moving within a section Private Sub Btn_MoveCtrl_Click() Txt_ID.Move End Sub Thank you

Yeah, you're right. We were on wrong debugging direction with that given weird error msg.

Hi Majp. Thank for your valuable time of debugging. At first, the problem is solved. We found the issue on post #19 Yeah, my vendorID is random number, I dont want increament number as if someone see that they can estimate how many vendor/customer I have in system. The local language...

Yeah, I already changed my query like that, so there is no potential issue if we add new field on TBLVENDOR in future. Howeverm abit concern, if a table on network db has many fields, getting TBLVENDOR.* might slow down performance while i just need few fields. Right? In fact, my project has...

I did not say it is Access's error. Post #20, @Josef P. has mentioned it too, developer makes a wrong SQL on filter string, however Access does not notice error when applying filter but it only noitice when we change current record on subform. It makes we not think the problem comes from...