Refresh a list box

[Orabidoo]

Hi everybody,



I'm new to Access and I'm trying to make a command button refresh a list box (it's based on a query and lists people of the same gender, I use option buttons to set the desired gender). I used the wizard and chose Form operations/Refresh form data, and I just get an error message.

Thanks!

[Orabidoo]

I made a macro that does a requery, it works!

[RuralGuy]

A little self help is always a good thing. Thanks for posting back.

[RuralGuy]

BTW, did you know all you need to do is requery the ListBox? Me.ListBoxName.Requery

[Orabidoo]

I tried that but that didn't work. I'll try again!

[RuralGuy]

Let us know the results. If it does not work then there is something wrong with your system and we can probably help there too.

[Orabidoo]

"BTW, did you know all you need to do is requery the ListBox? Me.ListBoxName.Requery"

I typed that right into the OnClick property field at first, but that didn't work. However, I discovered the VB code window and added the call there instead. It works now, thanks!

I'll probably come back with more questions soon.

[RuralGuy]

See how much wiser you are today than yesterday? Feels good doesn't it? You are welcome and have fun.

[Orabidoo]

So...I copied the file to my laptop and brought it to the office to show my boss. I opened the database and everything looked fine. Tried the form. Nope, didn't work. The list box didn't update. Does this have anything to do with the trust settings? Should it? This isn't a macro.

[Orabidoo]

Ah, that's it... But how does this work when you use the database seperately with the Access runtime?