Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Changes to the Tag Property 1

Status
Not open for further replies.

DrGreg1408

Technical User
Feb 8, 2008
30
US
I want to programmatically assign a value to the tag property of an open form and then save that change when I close the form so that I have access to it when I open it the next time. Sounds pretty straight forward, but I'm finding that the changes made to the tag are not being saved. Is this normal behavior for Access forms? Before anyone asks, my close command already includes the optioon acSaveYes. How can I have my form save changes to the tag property that are made programmatically while the form is open?
 

If I'm not mistaken, this type of permament change can only be made in design view. If you need to save the value, put it in a table.


Randy
 
Is the form open in design view ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 

You'd have to

Open a second form, passing the tag to it (maybe with OpenArgs)

Close your original form

Re-open your original form in Design View, assign the tag value to the control

Close the form using the acSaveYes option

Close the second form

Possibly re-open the originalform again.

All of which seems like a lot of song and dance for such little gain. Why not assign the tab value to a small "maintenance" table, then reload it when opening the form?


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
How are ya DrGreg1408 . . .

Instead of going thru the hassle of switching to form design view, consider [blue]Custom Db Properties![/blue] [purple]These properties are nonvolatile and stay with the Db![/purple] Close then open the Db and their still their!

Its a simple matter of creating the property per form required and then assigning values.

For insight into [blue]Custom Db Properties,[/blue] have a look at thread702-1236022 (6th post from the top).

[blue]Your Thoughts? . . .[/blue]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Thanks everyone for you help. I guess I never realized that the tag property can only be permanently changed in design view. Your solutions are very helpful. I am quite interested in exploring the topic of Custom DB Properties mentioned by TheACEMan.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top