Clear combo box selections from form

[h_aaron]

Good afternoon

Newbie warning - I do not know how to program in Access. But I've developed a database that uses a form to access a query to display a report. What I'd like to do is have a button that I can clear the selections in the form. I created a "refresh" button but I get the error listed below. I've also included a screenshot of my form. Thanks for any help you can provide.

"Command or Action 'refresh' isn't available now. *You may be in read-only database or an unconverted database from an earlier version or Microsoft access. * The type of object the action appies to isn't currently selected or isn't in the active view. Use only those commands and macro actions that are currently available for this database."

[June7]

Assume those are UNBOUND comboboxes used to input filter criteria.

Code behind button would set each combobox to Null or empty string (I use Null).

Why 4 comboboxes for same criteria?

Options to refresh the objects already open:

1. Click 'Refresh All' on the ribbon

2. VBA code: CommandBars.ExecuteMso "DataRefreshAll"

[Missinglinq]

I would also assume that the Form itself is Unbound

Two things:

First...if a Form has no Record Source there's nothing to 'refresh'...hence the error.

Second...'Refresh' is not intended to 'clear' the Controls on a Form.

The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment.

As June7 said...merely set the Combobox Controls to Null.

Linq ;0)>

[h_aaron]

To answer your questions -
1) yes, I 'believe' the form is unbound.
2) multiple Combo Boxes so that the user may select up to 4 buildings to review at a time. (I'm most likely going to add a Select All option)

I do like the Control to Null suggestion - however, as I mentioned, I'm a newb and have no idea how to do so. Would one of you mind providing me with instructions on how to do so? I do everything in Design View - sorry for being so difficult.

[June7]

Me.comboboxname = Null

Post your code if you need more help with it.

Are you using a dynamic parameterized query? Post the query SQL.

Review: http://allenbrowne.com/ser-62.html

Only 4 buildings? Could use a listbox to allow more. Allen Browne has sample code for that as well. A link is within the other.

[h_aaron]

Hi June7
I really hate to sound like I don't know what I'm doing - oh wait, I don't - but how do I access the code? I have never even seen the code. Can you tell me what I need to do to see the code?

Thanks.

I have over 40 buildings that I'm inventorying. Usually, we only review a few areas at a time - hence the 4 combobox. But, I'm always interested in how to do things better.

[h_aaron]

Ok, I finally figured out how to see the code - duh, "View Code" should have been an indicator. Below is what that showed me. Would you please tell me how I would insert the Null in here so it will reset all four combo boxes? Thx!!!



Option Compare Database


Private Sub cboBldgName1_Click()


End Sub


Private Sub Command14_Click()
End Sub

[ssanfu]

Since you state you are a newbie (we all were at one point ), maybe you would like a review of your dB?
You only show 2 forms, but there are 8 tables?

If you decide to post the dB, make a copy, delete all but 1 or 2 buildings, change sensitive data (address or building name), do a "Compact & Repair", then Zip it.

[Micron]

code editor is alt+F11 or if I recall, Ctrl+G (I only use the former)
but you are probably using macros? Can't see any in your navigation pane, so am guessing based on your comments. Sometimes we tend to forget that some very novice types do not know code at all, and mostly, we don't use macros so are sketchy on them.

But, I'm always interested in how to do things better.

A control for each option of the same type of thing isn't the way to go. List boxes are better than combo boxes in some ways, but these ways involve coding that might be too much for you at this point. A combo is simpler but you can't use multi select in it. Basically, anything that doesn't require you to modify a form design to accommodate a new choice is the proper approach, so this would exclude a checkbox for each option as well.

This sort of advice is well intentioned, but sometimes the complex is too much for beginners, and possibly we all are guilty of doing the very things we say not to do if we think back far enough - unless someone was just a wizard at this stuff from day one. I know I wasn't.

[h_aaron]

Oh My Goodness ssanfu - That would be awesome. And, Micron - you nailed it - macros & no code. But, I want to learn. I'll attach a zipped copy of my dB with sensitive data removed. Thanks to all of you!!!


,

[h_aaron]

Oh My Goodness ssanfu - That would be awesome. And, Micron - you nailed it - macros & no code. But, I want to learn. I was planning to attach a zipped copy but I keep getting an error message stating the file can't be uploaded. Any idea if I'm not allowed to attach zips? Thanks to all of you!!!


,

[h_aaron]

Argh. I can't get the file smaller than 5 MB. So close...

[ssanfu]

Sharing via Box, DropBox, One Drive?????

[h_aaron]

Durr.... Thanks for all your patience Steve - Here you go https://www.dropbox.com/s/448mn2jjbk...gmt.accdb?dl=0

[June7]

Just type it.

Private Sub Command14_Click()
Me.comboboxname = Null
End Sub

But use your actual combobox name. You will need a line for each combobox.

Me. is shorthand alias for the form or report the code is behind.

Advise you name your button something more meaningful (as you should for all controls, especially when referenced in code) than Command15, like btnClear. Then the procedure declaration would be:

Private Sub btnClear_Click()

If you have no programming background in any language, recommend you work through some tutorials. Knowledge of basic programming concepts is transferable. Then need to learn VBA language - more tutorials. Review https://access-programmers.co.uk/for...d.php?t=159756