Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old September 7th, 2017, 10:36 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
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:

 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"


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 Sub
    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.

Reply With Quote
  #2 (permalink)  
Old October 3rd, 2017, 02:25 AM
Registered User
Points: 26, Level: 1
Points: 26, Level: 1 Points: 26, Level: 1 Points: 26, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2017
Posts: 8
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:
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 10: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 08:35 AM

All times are GMT -4. The time now is 04:10 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.