Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 7th, 2017, 10:36 AM
Registered User
 
Join Date: Sep 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Post Parsing Info from one Form to Another in Access 2016

I am new at Access and using 2016. I am creating a database and have a form that I created a second page to. When my End Users click on the button to Page 2, it comes up blank.

What I want is for Page 2 of this form to automatically pull in the UniqueID, FullNme and ClientID. The rest of Page 2 is manually filled in. This would complete the form itself. The code that I have for the initial page is as follows:

Code:
 Private Sub Form_Open(Cancel As Integer)
On Error GoTo err_Form_Open

DoCmd.MoveSize , , , 14500

DoCmd.GoToRecord , , acNewRec

Dim Master As String

Master = "frm_Main_ADDP"

Com_Apply_for.SetFocus


DoCmd.Close acForm, Master, acSaveYes


Lab_final.Visible = False
Com_UnderRev.Visible = True
Lab_Final_Rev.Visible = False
Text_Final_Rev.Visible = False
Text_Pay_Month_Main.Visible = False
Lab_Pay_Month_main.Visible = False
Com_Next_Gender.Visible = False
Pag_Gen_Race.Visible = False
Fra_Spouse.Visible = False
Lab_Spouse.Visible = False
Text_Fam_Nme.Visible = False
Lab_Spouse_HIV.Visible = False
Fra_Spouse_HIV.Visible = False
Text_Spouse_HIV.Visible = False
Line_HIV_one.Visible = False
Line_HIV_two.Visible = False
Line_HIV.Visible = False
Com_Pos_Sp.Visible = False
Lab_HIV.Visible = False
Com_Close_Alt.Visible = True

Fra_Veteran = 2
Text_Vet = "NO"

Fra_Citizen = 1
Text_Cit = "YES"


exit_Form_Open:
    Exit Sub
    
err_Form_Open:
    MsgBox Err.Description
    Resume exit_Form_Open
    
    
End Sub

I am at a loss as to what to change to get page 2 to populate correctly. Any suggestions or assistance will be greatly appreciated.

MrsNLynah
 
Old October 3rd, 2017, 02:25 AM
Authorized User
 
Join Date: May 2017
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default MS Access form handling tips and tricks

If you want to know how to work with MS Access form then I think the tutorial listed in this section will surely going to help you. Just go through the form section in this tutorial section:





Similar Threads
Thread Thread Starter Forum Replies Last Post
2016 Version of this book ftaa55 BOOK: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer 0 November 16th, 2016 11:50 AM
XSLT for parsing XHTML Form shahbhat XSLT 6 August 26th, 2008 06:22 PM
How do I add up info for form validation? Lucy Javascript How-To 0 May 24th, 2005 04:44 AM
help w/ parsing ups tracking info mopacfan XML 0 May 18th, 2004 05:05 PM
Parsing a form menu esheard Javascript 2 March 11th, 2004 09:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.