How do I select tables tab when minimizing an Access app

[WantsToLearn]

We have a form that the user uses to process their data. On occasion they would like to browse the tables directly (I know, but that's what I was told to do). When I minimize the form, how do I select the tables tab to save a step for them?

Thank you!

 

[JeremyNYC]

You say you know, but you'll really learn once the user messes up his or her data and then start yelling at you about it!! What I would do is find out what the user wants to do and build more forms, so that they can get everything done. Really. I wouldn't let a user touch the tables without an explicit wanring that they are very likely to make the data in their database unusable when they do so.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[beetee]

If I understand you correctly, you would like to be able to browse the data in a datasheet view, then use a form to actually edit the data.

One means you could use to do this would be to create a form based on the table to be browsed; make the form datasheet view. Make it read-only.

Then, handle double click events in the datasheet form by opening the data entry form, doing a find record or using a filter to select the record the user double clicked.