UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Reset Parameter On Combo Box Query, Access 2016    
 
   
joelkrywolt
post Jul 12 2019, 01:33 PM
Post#1



Posts: 92
Joined: 18-July 07
From: Leduc, Alberta


I am looking for some advice on removing the parameter that was previously set on a combo boxes recordset (query) every time i move to the next row in a continuous form. (besides pressing F5)

The form's control is on a sub-form of a sub-form on the Main form.

I tried: Forms![mainform].form[subform1].form[subform2].refresh but to no avail... thanks in advance smile.gif

--------------------
Thanks in advance
Go to the top of the page
 
June7
post Jul 12 2019, 02:06 PM
Post#2



Posts: 648
Joined: 25-January 16



This is a cascading (dependent) combobox? You need to requery combobox?

Use subform's Current event and the AfterUpdate event of control the combobox is dependent on

Me.combobxname.Requery

What is the combobox RowSource?


This post has been edited by June7: Jul 12 2019, 02:07 PM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2019 - 05:24 AM