By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Refresh not available!!!

P: 15
Hi.
I am using form and subform in which form has combo boxes that sets the criteria for the query. i am using grouping in the select query and the contents of the query are displayed in the subform. as soon as i set the criteria in the query, the contents of the query are not displayed in the subform and the refresh button genrats the error statement "The Command or Action 'Refresh' isn't available now." please tell me the reason of this problem and its solution.
Aug 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: 16
I used this snip of code for a similar problem I was having.
On the event for before your subform should populate the data, call this public sub.
Make sure you change my form name to your object name.

Public Sub RequeryList()
'This was copied from the HELP section of MS Access
'It makes the list box refresh the information based on the
'selection made in the combo box

Dim ctlCombo As Control

' Return Control object pointing to a combo box.
Set ctlCombo = Forms!frmSectionSelect!lstParaInfo

' Requery source of data for list box.
ctlCombo.Requery

End Sub
Aug 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.