Popup Form Over Active Control with Return Value

In this Microsoft Access tutorial I will show you how to open a modal pop-up form directly over the active control on your form and position it accurately, making it easy to update fields like Last Name or Country. We will use VBA to capture which control was clicked, calculate its position, and open a custom modal form in that exact spot. You will also see how to pass a value from the clicked control to the pop-up form for editing. This is part 1.

Sandra from Norfork, Arkansas (a Platinum Member) asks: Could you show how to open a modal popup form above a specific control? I'm trying to use your popup calendar date picker and it would be nice if it opened on top of the date field.

Prerequisites

• Modal & Popup
• Intro to VBA
• DoCmd.OpenForm
• MoveSize
• ActiveControl
• ActiveForm
• TempVars

Recommended Courses

• Access Developer Courses

Up Next

• Popup Over Control, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, open modal form over control, pop-up form position active control, return value to calling control, date picker modal form, form MoveSize to x-y coordinates, ActiveControl VBA example, WindowLeft and WindowTop usage, reusable pop-up form function, TempVars demo, On Click event pop-up, MyModalF sample form, developer-level modal forms, form Left and Top properties, transfer form value VBA, pop-up over fields, navigation buttons modal off, max min buttons modal off, set ActiveForm ActiveControl, pop-up for subform field