Save Value After Closing and Reopening Form - Popup Over Control in Microsoft Access, Part 2


	Back to Popup Over Control 2 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Save Value After Closing and Reopening Form

James Hopkins

8 months ago

Hey Richard and Guys,

I have created a Modular Form that I use to Add Events for a Property. But the problem I have is that I have one Button, "Enter Another Property for this Customer". I am trying to figure out what is the best way to do this. Should I use TempVars to store the Customer Name when closing the Form and set the Customer Combo Box when reopening or something else. Thanks in advance Guys.

	Sami Shamma @Reply 8 months ago
Please be more specific. See Rule #2. A red flag is raised immediately when you are talking about customer name as your identifier instead of customer id. Please show your property table, event table, and customer table

	James Hopkins OP @Reply 8 months ago

	James Hopkins OP @Reply 8 months ago

	James Hopkins OP @Reply 8 months ago

James Hopkins OP @Reply

8 months ago

The Code in the Button:

Private Sub BtnOpenNewPropertyFm_Click()

    Forms(TempVars("PreviousForm")).Controls(TempVars("PreviousControl")) = CboClient
    DoCmd.Save , "PropertyF"
    DoCmd.OpenForm "PropertyF", , , , acFormAdd
    Forms!PropertyF!LblPropertyFormHeader.Caption = "Add New Property"
    Forms!PropertyF!CboClient = ClientID
    DoCmd.Close , "PropertyF", acSaveYes
    DoCmd.Close , Me.Name, acSaveYes

End Sub

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Popup Over Control 2.

Next Unseen

New Feature: Comment Live View