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    
post Jul 12 2019, 01:33 PM

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
post Jul 12 2019, 02:06 PM

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


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