Results 1 to 6 of 6
  1. #1
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338

    Popup New Form

    Hello




    Need little help on how to build a popup form. My main form (FTOpenBalanceForm)is going to have about 14 tex box. I need to add more text box (DeptName,Address)to the form but it's going to be too much in one form and these text box won’t be used as much. I would like for the user to click on PmtsentToAnotherDept from the main form and a new form (FTOpenBalanceFormPMTDeptSentTo)would pop up for the user to enter data.
    I setup FTOpenBalanceFormPMTDeptSentTo form to popup. How do i link the same id from the main form to the form that popup?

    Main Form(FTOpenBalanceForm)

    ID BillingProviderLastName PtAcct PtProcCodeCPT PtLastName PtFirstName PtCategory SvcDateStamp SumOfCharges SumOfPayments SumOfAdjustments Balance Status Date User Comments PMTSentToAnotherDept
    1414 Smith 1524 1170F Doe Sandy N/A 5/23/2014 0.01 0 0 $0.01 TRUE

    Popup Form (FTOpenBalanceFormPMTDeptSentTo)

    ID DeptName Address
    1414 PA 1975 River st



    Build a new query for the popup form (QTOpenBalanceFormPMTDeptSentTo) not sure if that is correct.
    Here is a copy of the db

    Database4.zip

    Thank you

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,535
    Why not use a tab control on the form with the lesser used controls on a separate page of the tab.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    Never really used tab control.
    On the main form it would display multiple patient at the same time for each provider. Would this tab control be able to display all data as a continuous form?

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,535
    Quote Originally Posted by Ray67 View Post
    Never really used tab control.
    On the main form it would display multiple patient at the same time for each provider. Would this tab control be able to display all data as a continuous form?
    Sorry, I don't understand what you are saying here.
    I have downloaded your db but I only have A2003 on this machine. Will look at the db tomorrow when I have A2013 to hand.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    Can have a form set to Continuous and have tab control. I've never set up a form like this but just did a little test and seems to work.

    Or can put a continuous subform on page of tab control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    Does work

    Thank you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. popup form
    By Cosmo Monkey in forum Forms
    Replies: 1
    Last Post: 03-25-2013, 03:06 PM
  2. Popup form
    By marcsessoms in forum Forms
    Replies: 8
    Last Post: 02-17-2012, 08:53 PM
  3. form popup
    By fabiobarreto10 in forum Forms
    Replies: 30
    Last Post: 01-19-2012, 01:54 PM
  4. Popup form
    By triplee23 in forum Forms
    Replies: 1
    Last Post: 10-24-2010, 04:09 PM
  5. Popup Form
    By NISMOJim in forum Forms
    Replies: 1
    Last Post: 10-23-2010, 09:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums