Forms :: Pre-populate Popup Form After Update To Another Form

Aug 27, 2013

I have two tables - Interviews & Placements.these tables have multiple foreign keys which pull information from other tables (CandidateID,ClientID etc). I have designed queries and forms (datasheet view) which display all the values that I need, For example:

The interview form shows the following fields:
CandidateName;Company;consultant;1stInterviewDate; 2ndInterviewDate;Offer;Accepted

the placements form shows the following fields:
PlacedCandidate;Company;Consultant;PlacementDate;F ee;

This query "qry_Interviews" populates these forms using the foreign keys:

CandidateID from candidates table
CompanyID from companies table
consultant from consultants table

Ideally what I'd like to happen, is when the "accepted" field is updated on the interviews form, the placements form opens as a pop up and is auto populated with the values (CandidateName;Company & consultant).So far I have tried setting the value directly, i.e on the "on Open" event of the Placements form I entered:

Me.Txtcontactname = Forms!ISISnavigationMain!navigationSubform.Form!DS .Name

This does not work. Should I be populating the placements form with the actual Foreign key values rather than the resolved names? Ideally I'd want the pop up placements form to display the actual names rather than just ID numbers.

View Replies


ADVERTISEMENT

Selecting A Field From A Popup Form To Be Populate Another Text Box

Apr 6, 2008

I have a field on frmOutpatient which is called EpisodeID.
I need to populate this field from a selection in a pop-up form.

The pop-up form (frmSelect) is a continuous form with a number of different EpisodeID numbers according to the date the patient was admitted. At the end of each record I want to put a command button (cmdSelect) and when pushed I want this SelectEpisodeID to be transferred to the field on the frmOutpatient.

Any ideas??

View 6 Replies View Related

Update / Refresh A Form Upon Entering Data In A Popup Box / Form

May 24, 2005

I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.

**************************************************
Scenerio:

I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.

Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.

Million Dollar Question:

How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.

**************************************************

Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool:

Thank You

View 1 Replies View Related

Forms :: Requery Form And Subform After Popup Form Close

Aug 19, 2013

I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.

Form 1
subform 1 > button to open pop up form
subform 2
subform 3

I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.

On pop up form close, what's the correct syntax for re-querying subform 1?

View 2 Replies View Related

Forms :: Button In Popup Form - Set Focus To Another Form?

Jan 28, 2015

How can I make a button in a pop-up form to send enter key to a text box in another form? Do I need to set focus to the other form first? And how?

View 1 Replies View Related

Forms :: Display Value Of Control Within Popup Form

Jul 25, 2013

I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.

View 4 Replies View Related

Forms :: Size Of Modal Popup Form

Aug 27, 2014

I am having issues with a split form which modal and emergent (pop-up) properties are set to yes. When I open it, it is maximized or out of the size I had setup; although I saved it trying to "freeze" the height and width.

View 11 Replies View Related

Forms :: Filter A Popup Form With Subform?

Jul 29, 2015

I have a continuous Form [Letter Log - All] with "LetterNo" field as the primary key. What i want to do is click the "LetterNo" and a filtered pop up form with subform should appear based on what has been clicked. But i don't have luck doing that. The name of the main form is "LetterLog" and its subform control name is "LetterLogSub"

here is what i did.

Code:

Private Sub LetterNo_Click()
'DoCmd.OpenForm "LetterLogSub", acNormal, , "LetterNo = " & Me.LetterNo, acFormEdit, acDialog <-- this one works but without the subform
'DoCmd.OpenForm "LetterLog", acNormal, , "Forms!LetterLog!LeteterLogSub.Form.LetterNo = " & Me.LetterNo, acFormEdit, acDialog
'DoCmd.OpenForm "LetterLog", acNormal, "LetterNo", "me.LetterLogSub.Form!LetterNo = " & Me.LetterNo, acFormReadOnly, acDialog
DoCmd.OpenForm "LetterLog", acNormal, "LetterNoFilter", "Forms!LetterLog!LetterLogSub.form!LetterNo = " & Me.LetterNo, acFormEdit, acDialog
End Sub

View 7 Replies View Related

Forms :: Change A Subform To A Popup Form

Sep 24, 2013

I had a subform to enter payments. It worked well. The master and child fields linked well and all the necessary data appended to a new record in the payments table.

Now to make it more user friendly, I changed the subform to a popup form (The 2 forms took up too much real estate on the screen).I deleted the payments subform and created a command button to open the payments form as a popup.

I need 3 fields on the payments form to be populated from the edit sponsor form (sponsorID, MemberID, SponsorTypeID) and then payment details to be entered and posted to a new record in the payments table.Since I've changed the payment form from a subform to a popup form, the master/child relationships are gone and the 3 fields I need for the payment record no longer appear.

View 1 Replies View Related

Forms :: Adding New Record Using Popup Form?

Oct 25, 2013

I'm working on a database that has a subform which pulls its data from a table and I'm trying to use a popup form to enter the data in the sub form. For example the table is called student debts. The form is called student debt. The pop up form is called student debt entry from. I want the inform that's in the student debt entry form to be recorded in the student debt form which is a subform on the main form. I know i have to create a add new records button to do it but not sure of the code.

View 4 Replies View Related

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Saving A Record And Closing A Popup Form

Jun 15, 2014

I have a popup called by a subform to add a new record or edit a selected record. I keep getting "Runtime error 32502". The value you entered isn't valid for the field "|"

I have no required fields and all the drop down related fields have the right value type in them (That I can find)The only "|" reference I can find is in the OpenArgs content below when I load the form. If I'm adding a new record I pass two fileds via the OpenArgs

Private Sub Command52_Click()
DoCmd.OpenForm "AddDebtorPaymentFrm", , , , acFormAdd, OpenArgs:=Me![DebtorId] & "|" & Me![MatterId]
End Sub

or if I'm modifying a record from the subform on click I

Private Sub Text38_Click()
DoCmd.OpenForm "AddDebtorPaymentFrm", acNormal, , "[Transactions].[TransId] = " & Me.TransId, acFormEdit
End Sub

Below is the Popup Load code

Private Sub Form_Load()
If Me.DataEntry = True Then
Me.VariableHeading = "Add A Debtor Payment"

[code]....

View 8 Replies View Related

Forms :: Popup Form Updating Incomplete Records

Jan 21, 2014

I have a popup form that user will select for updating 4 fields in table. I have a update button that has code behind it that verifies the record is complete before closing the popup form. That works well.

However, I want to add an abort button that will close the form and save nothing entered however, I getting incomplete records and blank records. How can I code the button to not update the table and just close the form?

View 2 Replies View Related

Forms :: Cannot Get Edit Access In Popup (Confirmation) Form

Jul 7, 2014

I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table that simply stores that one record temporarily.

So when the user is finished entering their current transaction, I have a Save button that actually just opens a popup form which displays the data they entered into the data entry subform, giving them a chance to verify their entry is accurate. This form has a Save button which runs an append query and a delete query, adding the record to the permanent Transacations table and also clearing the temp table.

The problem I have, I think, is that when the popup form opens, the main form data entry subform still has that record locked as exclusive. I believe this is the case because while I am indeed able to make changes to the fields on the popup form, none of these changes appear in the temp table. In other words, the user is not actually able to use the confirmation pop up form to make any necessary edits to their entry. This makes the form sort of useless!

View 1 Replies View Related

Forms :: Populate Field In One Form From Text Box In Another Form

Jan 18, 2014

There are two forms invoolved in thi

pfrm_AddClientPrimary
pfrm_AddClientDuplicateCheck

On a command button in pfrm_AddClientDuplicateCheck I have the following code.

Code:
Private Sub cmdAddNewClient_Click()
DoCmd.OpenForm "pfrm_AddClientPrimary"
DoCmd.Close acForm, "pfrm_AddClientDuplicateCheck"
End Sub

This works great

On the onOpen event of the pfrm_AddClientPrimary form I have this code

Code:

Private Sub Form_Open(Cancel As Integer)
Me.FirstName = Forms!pfrm_AddClientDuplicateCheck!txtFirstName
Me.LastName = Forms!pfrm_AddClientDuplicateCheck!txtLastName
Me.SocialInsureanceNumber = Forms!pfrm_AddClientDuplicateCheck!txtSOcialInsureanceNumber
Me.FirstName.SetFocus
End Sub

This fails on the first line with this error
Run-time error 2147352567 (80020009)
You can't assign a value to this object

I am aware of the incorrect spelling of Me.SocialInsureanceNumber this is the way it is in the db.

View 4 Replies View Related

Conflicting Requirements Between Popup Forms And Main Form's Fields

Jan 23, 2006

I have set certain fields on my main form to be required to protect from accidnetal skipping which has occured in past. However, in middle of form, there are a group of checkboxes, which opens their correndsponding popup forms for more details. Right now, I get an error if it try to pop up a form because not all required fields are filled in.How do I make Access suspend the requirments whenever the checkboxes are checked and additional info are being inputed?Edit= tried setting it as dialog boxes, but to no avail.

View 9 Replies View Related

Forms :: Right Click Menu In Popup Form On Access 2010?

Dec 11, 2013

I'm trying to do right click menu on listbox.

currently i'm trying to implement a right click menu which will show a simple messege box.

My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.

It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).

I'm running the following vba code:

This is the mouse up event handler for my list box:

Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Call the SetUpContextMenu function to ensure it is setup with most current context
' Note: This really only needs to be setup once for this example since nothing is

[Code] .....

setting up the "SetUpContextMenu" sub:

Public Sub SetUpContextMenu()
' Note: This requires a reference to Microsoft Office Object Library
Dim combo As CommandBarControl
' Since it may have been defined in the past, it should be deleted,
' or if it has not been defined in the past, the error should be ignored

[code].....

View 3 Replies View Related

Forms :: Setting Popup Reminder On Form Load For Expiry Date

Jul 26, 2015

I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).

I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).

View 2 Replies View Related

Use Popup Form To Select A Record On Main Form

Sep 2, 2006

I'm not sure how to search on this, even in the advanced search. If this has been answered, could you point me in the right direction?

I have a main form AddNewCompany (the infamous tab control that now works - thanks to your combined efforts). On it I have a command button that pops up a form of continuous forms with all the companies in the table (the query calls the CompanyID and CompanyName fields only). I have attached an image of the interface.

This means the user can see if the company already exists and doesn't enter it again. (I'm sure there are more effecient ways of doing this, but this is simple and it works. I also know key fields should be autonumbers instead of text, but I have reasons for doing it this way).

What I would like to be able to do is click on the CompanyID field and have the companies information show up in the main form.

View 14 Replies View Related

Use Popup Form To Select A Record On The Main Form

Sep 4, 2006

Can anyone see what I am doing wrong?

I have a main form that has a tab control on it. The main form is called frm_AddNewCompanyContacts. It is opened in edit mode. To see if a company exists I use a command button to call a popup form with a list of all companies' IDs and names. I then want the user to be able to click on a commad button on the popup form to take the main form to that record. After an intial post, and subsequent search, I found the appropriate code. This is what I am using for the onclick event of the command button on the popup form:

Private Sub cmdGoToCompany_Click()
Dim rst As Recordset
Set rst = Forms![frm_AddNewCompanyContacts].RecordsetClone
rst.FindFirst "[CompanyID]='" & Me![CompanyID] & "'"
If rst.NoMatch = False Then
Forms![frm_AddNewCompanyContacts].Bookmark = rst.Bookmark
End If

End Sub

When I click on the command button I get an error message:

"The expression On Click you entered as the even property setting produced the following error: A problem occurred while Microsoft Office Access was communication with OLE server or ActiveX Control (I don't have an ActiveX Control).

*The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure].
*There may have ben an error evaluating the function, event or macro."

View 10 Replies View Related

Modules & VBA :: Linking Popup Form To Main Form

Jan 23, 2015

I have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be able to press a button and have the second tables form pop up and add that that specific Project_Number. I added the button and went through the wizard process. I then added the linking info through the builder. It works fine if there is already data entered for the project_number in that specific field. but if the field is empty, the popup window doesn't recognize a project_number and doesn't add it to that record. below is what I am using. The project_number in the 'main' table is text and the Project_Number in the 2nd table in a number since it is a lookup field.

Private Sub CongressionalDistrictCmd_Click()
On Error GoTo Err_CongressionalDistrictCmd_Click
Dim stDocName As String

[Code]....

View 9 Replies View Related

Forms :: Using A Scanner To Populate A Form

Oct 22, 2013

I have a table which contains 2 fields. UserID and FullName..Each employee is assigned a barcode (UserID) and what I would like is when they scan their barcode into the form their name comes up. There is a second table containing records of documents and I am hoping that this form will allow an employee to scan their ID, their name comes up, scan a document and the title of the document comes up, there would be a current date box and then that whole transaction is saved as a record in another table. Long story short I want to know who is accessing what records and to have it logged.

View 5 Replies View Related

Forms :: Open And Populate A Form

Jun 12, 2014

I am trying to open a form from my main form and populate fields from one to the other (then press a button).if the form is opened in dialog mode then the code won't run to populate the form (until it is closed or not visible).

The main form is showing an address, but the user can click a button to amend this. Once clicked, the Property Form is opened - I don't want the user to need to fill in all the address details again. I want this pulled through from the main form so the user can make an amendment, then save the new address.

Code:
DoCmd.OpenForm "frmPropertySearch", , , , , acDialog
With Forms!frmPropertySearch
.Form.Visible = False
If Not IsNull(Me.Building_Name) Then
strBuildingName = Me.Building_Name
.txtBuilding_Name = strBuildingName
End If
End With

View 3 Replies View Related

Forms :: Populate A Tabbed Form With A Different Record On Each Tab?

Sep 28, 2014

how to populate a tabbed form with a different record on each tab?

View 3 Replies View Related

Forms :: Populate Form Control With OpenArgs

Sep 19, 2014

I have this code in a button on my Patient Form:

Code:
DoCmd.OpenForm "frm_Admissions", acNormal, , , acFormAdd, , "NHS Number|" & Me.[NHS Number]

And this in my Admissions form LoadEvent:

Code:
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant

[Code]....

The expression you entered refers to an object that is closed or doesn't exist

Borrowed code from: [URL]

View 5 Replies View Related

Forms :: Populate Combobox Value With Open Form

Aug 13, 2014

I have a unbound combobox in my form. I wanna populate list value in my combobox. first value is current year. Every time populate 6 values. like as

2014-2015
2015-2016
2016-2017
2017-2018
2018-2019
2019-2020

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved