Recent content by RickSanchez

This worked, thank you!

How do I make the subform "save"? Also, why do you think it's not a good idea to save?

That's my account. I chose to ask on here as well because I wasn't getting any answers on SO. When I get an answer somewhere, I can delete the question on the other site.

That would work if I create a dedicated Close button, but then when I'm doing development, it still prompts me to save when I hop back and forth between form view and design view. Ideally, I'd like to modify the subform's property and then save it somehow.

In the main form's On Open event

I have a main form where, on the main form's On Open event, it changes the properties of a subform query by hiding/showing a column, depending on the user's permission level: Private Sub Form_Open(Cancel As Integer) If IsUserInGroup("CostPrice") = True Then...