Closing Datasheet Forms Within Each Other

[jfriedm]

Hello,



I've got a Datasheet form which has a Datasheet Subform within it. By default, none of the subforms display, and the user clicks the "plus" on the leftmost column. What I'd like to do is prevent a user from having multiple subforms open at once. Basically, when the user clicks to open another subform, the first one closes.

How can this be done?

Also, is there a way to do conditional formatting (either using the wizard or with vba) on datasheet forms?

[June7]

Never tried Datasheet form/subform arrangement.

I have used Conditional Formatting on Datasheet view.

Want to provide db for analysis? Follow instructions at bottom of my post.

[jfriedm]

Hi June7,

Unfortunately, I can't post the DB here -- it connects to a local sql server that isn't accessible outside of our network, so it wouldn't work.

Jason

[June7]

Could make copy of frontend, import tables relevant to the issue.

[jfriedm]

Hi June7,

Attached is a dummy database that does basically the same thing as mine.

I've solved the conditional formatting issue (bad formula).... but not the ability to close one subform when another is opened (or alternatively, close the previous subform when another primary record is selected).

test.accdb

[June7]

You have to click the - (minus) symbol to close the subform.

I have never built a db that offers this setup as user interface.

Review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[jfriedm]

Yeah that's what I'm trying to avoid... because in my actual DB there is vb activity each time the form loads (based on parent content), I need a way to ensure that only 1 subform is open at once.

[June7]

Odd, not getting the +/- to go away in form even though did in table.

[jfriedm]

I'm fine with leaving the +/- in the form... just need it to automatically close when another record is selected.

[June7]

Don't think there is any way to manage that behavior programatically. Think that functionality is intended for use in viewing tables/queries. For using forms, consider the option I referenced. It does work and I did figure out why the +/- didn't go away.

[jfriedm]

Don't think there is any way to manage that behavior programatically. Think that functionality is intended for use in viewing tables/queries. For using forms, consider the option I referenced. It does work and I did figure out why the +/- didn't go away.

What's the option you referenced?

[June7]

The link in post 6 describes a method to relate two forms set in datasheet view.