Solved

Access 2003 - Add a new record want subform to pop up and populate with inform from main form

Posted on 2007-11-30
4
611 Views
Last Modified: 2013-11-28
I have an Access 2003 form. It is patient history/information. When I add a new visit for that patient I would like to be able to have the form pop up to add this information and then also populate it with some information from the main form.
0
Comment
Question by:Pdeters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Shanmuga Sundaram
ID: 20382866
yes. you can do. try coding via vba.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 20383004
open your popup form with the patient id as open args

docmd.openform "frmVisit", openargs:= me.patientid

in the load event of the popup form

private sub form_load()

if  not isnull(me.openargs) then
    me.patientId=me.openargs
end if

end sub
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 20383062

better to open the form in add mode

docmd.openform "frmVisit",datamode:=acformadd, openargs:= me.patientid
0
 

Author Closing Comment

by:Pdeters
ID: 31411926
worked wonderful!!!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question