Filter checkbox upon opening form

[vickster3659]

Hello,
I need a bit of assistance with a form that has a checkbox called ReleasedAtBank. I would like this form to open with only the records that are not checked in this field. I have tried a few suggestions from this forum but am not getting the desired results.



Thank you, assistance is greatly appreciated!
Vickster3659

[ranman256]

Where ever you call this form to open, you need it to start with the FALSE recs.

docmd.openform "frmMain",,"[ReleasedAtBank]=false"

If you want to see ALL recs after it opens, just turn off the filter (the funnel icon)

[vickster3659]

Thank you!
It didn't work at first, but while messing around with your line of code, it works with this:

docmd.openform "frmMain",,,"[ReleasedAtBank]=false"


Another question.....I designed this form to open in datasheet view, but now with this code it is a form with a background, then you have to click through the records. Is there a way to display the form in datasheet view to see all of the filtered records?

Thanks,
Vickster3659

[ranman256]

oops , sorry..i missed a comma.

Datasheet?....Then you really dont need the form. Use a query that filters on your criteria.

Datasheet forms are really for subform lists.

[vickster3659]

No worries
THe reason I want to use a form is I have an audit process in place that works off of the Before Update, After Update, etc., which can't be done using queries according to the individual who wrote the code. Is there another audit process that can be done using queries?

[ranman256]

Not sure what the audit process it, but
Query = datasheet Form
they are the same thing.

[vickster3659]

The audit process is to keep track of changes to the records. In my process, a person will open the ReleasedAtBank form and see filtered (false) records. Once these records are "accepted", this person will put a check in the ReleasedAtBank. When this is done, the audit process will record the changes to an audit table.

No worries.....when clicking on the View button in the toolbar, there is the datasheet option. I was just hoping that the form would open always to that view. It's just another click.....

Thanks for your help today!

[Missinglinq]

Query = datasheet Form
they are the same thing.

Not true. A Query is displayed in a datasheet format, but it is not a Form, and does not have Form events such as Before Update, After Update, etc., which the OP is using!

When opening a Form in Datasheet View, using DoCmd.OpenForm, you have to do so explicitly, using the acFormView parameter:

DoCmd.OpenForm "frmMain", acFormDS , , "[ReleasedAtBank]=false"

Linq ;0)>

[vickster3659]

Excellent! Thank you Linq, this is exactly what I needed. Trying to make this process easy for the Access User Newbies!

Appreciate everyone's help.....I am a VBA rookie....I learn so much every time I visit the forum!

[Missinglinq]

Glad we could help!

Linq ;0)>