Open Pop Up Form Using Anothers Forms Name As The Criteria

Jan 19, 2006

okay, i have presented my database to my boss.

apart from the ongoing problem of trying to get a listbox and subform the same to the user, he has asked me to do something more

he wants me to be able to select from the menu, a selction that will open up a pop up form, from which notes can be made relating to the originating form

i presume the linking criteria will use the form name plus the record criteria the originating form is bound to

any help on how i go about this will be greatly appreciated

View Replies


ADVERTISEMENT

Forms :: Open A Form With Filtered Criteria?

Apr 9, 2014

I'm trying to open a form with filtered criteria using this code:

Code:
DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]=# " & Format(Me.Date, "dd/mm/yyyy") & "# And [Supporter_Name]='" & Me.Supporter & "'"

it used to work on access 2010 but now on access 2013 I get a blank form.

View 2 Replies View Related

Forms :: Using TempVars For Form Open Criteria - New Or Edit Record

Apr 23, 2014

MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record.

Two sets of forms - One set works perfect but the other will not accept the criteria for New Record

MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work.

Just before the If Then, an invalid use of Null message appears.

View 2 Replies View Related

Criteria On Open A Form

Nov 16, 2005

I was wondering if it was possible to add a parameter to the record source Query of a form depending on the value of an other field on the open event of the same form?
I was thinking to use 3 Sql statment SQL1, SQL2, SQL3, on the open event of the FrmOpen.
On Open then the RowSource of FrmOpen =SQL1
If field? = "A" Then
the RowSource of FrmOpen=SQL2
Else
the RowSource of FrmOpen=SQL3
End If
I did try but it doesn't work so I needed to know if it was possible to achieve this or not?

View 1 Replies View Related

Modules & VBA :: Multiple Criteria To Open A FORM

Apr 17, 2014

How to open FORM which has "inner join" in source?

Code:
...
Dim idRS As DAO.Recordset, ShowIdentity
strSQL = "INSERT INTO tblZlecenia (id_zlecenia_info, DataPrzyjecia) VALUES ('" & _
ostateczne & "', " & _
Format(Date, "#mm/dd/yyyy#") & ")"

[code]....

View 5 Replies View Related

Queries :: Set Criteria On A Query Based On If A Form Is Open Or Not?

Jun 18, 2015

What I want to do is set the criteria of a query to the value on a form if the form is open, and set it to a different value if the form is closed. I tried using a function on the OnLoad event of the form to set a variable called IsOpen to 1 if the form is open, and reset that variable to 0 when the form closes, but when I tried using the variable in an IIF statement in the query criteria, I got a "Its too complex" error.

Here's what I really want to do. I have a very complex form with multiple tabs and subforms. The subforms populate based on a query of what is selected and loaded into a textbox control on the first tab of the form. The first tab has a subform that is based on the main table. Rather than recreate that form, I want to copy it and change the rowsource on the first tab to a subset of the main table, and tell the query to use the textbox on the new form so I don't have to go and replicate all the other subforms. Is there a way to do that or am I just screwed?

View 3 Replies View Related

Open Form, Link Criteria, Filter, Cant Set Default Value To A Control.. Why?

Dec 15, 2006

Private Sub btncard_Click()
Dim stLinkCriteria As String
DoCmd.RunCommand acCmdSaveRecord
stLinkCriteria = "[jobref]=" & "'" & Me![jobref] & "'"
DoCmd.Close
DoCmd.OpenForm "k_job_card", , , stLinkCriteria
End Sub

this button code opens the k_job_card form.

the form opens and says 'Record 1 of 1, (Filtered)

i have a control on the form that opens.. and i am simply trying to assign a default value to that control..

it is a textbox.. for my jobtype field (text datatype)..

is there any particular reason why i cannot assign a default value to a control if it has been placed on a form that has been opened using a form filter?

this is how the Form Data tab is set at the moment..

View 3 Replies View Related

Forms :: When Open A Form / Want To Open Another From At Same

Jan 14, 2015

when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.

View 2 Replies View Related

Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form

Mar 26, 2013

Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.

I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.

View 5 Replies View Related

Forms :: Open Blank Form Based On Value In Text Field In Main Form

Jun 6, 2013

I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,

Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website

Table:StaffContact
Staff Role
Name
speciality
email
phone

I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.

Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).

Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)

My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has

So i ran a Macro, with open form with Where condition

Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]

But, it does not work .

View 2 Replies View Related

Forms :: Continuous Form With Command Button On Each Record To Open Another Form

Jul 30, 2014

I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.

At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.

continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"

pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"

This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):

1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid

2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid

3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria

4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub

View 9 Replies View Related

Forms :: Navigation Form - BrowseTo Command To Open Up A Form In Built-in Subform Module

May 3, 2013

I'm working on the Navigation Form template in Access 2010, which is new to me. It appears that one needs to use the BrowseTo command to open up a form in the built-in subform module. I'm trying to create a couple of buttons where each button opens a form in a different data mode; one in read-only and one in add mode. Here is the syntax I used for read-only:

DoCmd.BrowseTo acBrowseToForm, "frmSales","frmNavigation.NavigationSubform", , ,acFormReadOnly

frmSales is the Sales form I want both of the buttons to open and frmNavigation is the Navigation form. It seems to be ignoring the data mode part at the end however. It only will open in Edit mode. Is there something I'm doing wrong with this command?

View 3 Replies View Related

Forms :: Double Click Record In One Form To Open New Form?

Jan 27, 2014

I am trying to create a proposal log for my company to make things easier to track. I have made a multiple items form to list the proposals. I want to be able to double click the record to open up another form (that i have already created) that shows the information from the proposal table and the proposal details table. So.....

I want to double click the field named "Proposal Name" and have it open up to form i have called "proposals details form".

View 3 Replies View Related

Forms :: Open New Form With Record Data Sorted From Another Form?

Apr 2, 2014

I have a main form[frmResearchNotes] with combo box controls that filters a query populating [subfrmNotelist] containing several records from the filtered query. From there, I double click on a field within one of the remaining records, [CompanyName] for example, and it opens the new form[frmNoteDetail]. The problem is that second form is not displaying that selected record. The second form's record source has been set to the same query so when it loads, it displays the same info but it's displaying the 1st record out of the entire filtered list, not the record I clicked on in that list.

I figured I could use the strWhere function to copy the record I selected in the event procedure and then open the new form with those details. Not sure how to actually do this with VBA or if it's even the correct approach.

View 14 Replies View Related

Forms :: Open Form Directly Inside Navigation Form?

Oct 28, 2013

I would like to know if it's possible to open an specific subform inside a navigation form using an event.

I also need to to this using macros ( really can't use vba in this project =/)

Form example:

the main form has "nav_opt1", "nav_opt2", "nav_opt3"

By double clicking a record in "nav_opt1", it will open "nav_opt2" with some filters (but all in the same window), as if I was just browsing through the navigation forms usually.

View 1 Replies View Related

Forms :: Open Second Form On Related Field From First Form?

Aug 22, 2013

how to write code to open a second form on the click of a button on the first form and specifically to continue on the record set I am focusing on.

I have 2 tables. The first is tblAccount (fields: AccountID [the PK]; AccountHolder) and the 2nd is tblUser (fields: UserID [the PK]; UserName; AccountID). They are linked so that one account can have multiple users. Each has a respective form; frmAccount and frmUser.

My goal is that once the AccountHolder field has been populated in frmAccount I can click a button to open frmUser with the AccountID field already showing in the form header.

I have managed to do something similar by selecting from a combo box before but I am having trouble making this work after directly populating the AccountHolder field and using an open Form button.

View 2 Replies View Related

Forms :: Open A Form Based On Current Form?

Nov 23, 2014

When I have a form called "SiteForm" open and click a button "NewCalloutButton" I would like it to open up a form called "CalloutFormEntry"

I've done this using

Private Sub cmdOpenDetail_Click()
DoCmd.OpenForm "CalloutFormEntry", , , "CalloutID = " & Me!CalloutID
End Sub

However this brings up all the records linked to the calloutID

What I'm after is to open the CalloutFormEntry from the SiteForm in a dataentry kind of format but to carry over the current SiteID based on which site is open on the SiteForm. That way there's no user error logging callouts to incorrect sites.

View 9 Replies View Related

Forms :: Open A Form With Subform From Separate Form

Oct 23, 2014

I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error

Code:
Method 'Form' of object '_SubForm' failed.

After that, it opens (subform and all), but some calculated text fields just say "#Name?#"
The only thing I did today was add a command button to that subform.

When I try opening the form (or subform) from the navigation pane, I get

Code:
The expression On Current you entered as the event property setting produced the following error:

A problem occurred while Contracts was communicating with the OLE server or ActiveX Control

When I step through the code, it doesn't reach the On Current event.

View 5 Replies View Related

Forms :: Open A Form With Previous Forms ID

Sep 17, 2014

I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens...

Private Sub Command12_Click()
DoCmd.Close
DoCmd.OpenForm "Frm2"
End Sub

But I want it to open Frm2 using the ID from the previous form. The stumbling block for me is I close the first form before opening the next so I cant pass the ID across.

View 2 Replies View Related

Forms Open In The Middle Of The Form

Dec 21, 2006

I have several forms that open in the middle of the form instead of at the top in the first field. Any ideas to correct this problem?

View 2 Replies View Related

Forms :: Option To Open One Or Other Form?

Dec 24, 2014

how to give the option to open either forma or formb with a command button.

View 1 Replies View Related

Forms :: Open Form From Combo Box

Jun 3, 2014

Im using the below code to open a from depending on what option is selected on a combobox.

Code:

Private Sub DirectPCombo_Click()
Dim cboVal As String
Dim stDocName As String
cboVal = Me.DirectPCombo.Value
Select Case cboVal
Case "One"

[code]....

If you select the first item [One] it will open the correct form [TestOne]. But when you select any of the others an error comes up saying that the name is no a form. So I added

Code:
DoCmd.OpenReport stDocName

But the no items would select.I know If split the reports form the forms and make two comboboxes it would work, but it would be better it both could be in the same combobox.

View 2 Replies View Related

Forms :: Open Particular Record In Form?

Sep 13, 2013

I have a continuous form that is based on a query. I would like to have an open button so that you can select a record on the form and that particular record opens up in a new form. How do I do this?

If this cant be achieved would I be able to make a form open that shows a particular record based on the query and you just press next record to view the other records that are a result of the query?

View 6 Replies View Related

Forms :: Open Form From DblClick

Feb 8, 2015

I have a main form. It's only contents is an unbound combobox, and it's used to filter down (via a query) the details in it's sub form (I'm using it to load different account information, rather then type it in all the time).Anyway, I also have another form (Dashboard, or mainmenu) which summarises activity within Each account and is displayed via a datasheet.

What I'm trying to do is double click the accountname (on the main menu)which will then open up the necessary form and load the value from the datsheet accountname, in to the newly opened forms cbo, where I can apply the form to requery on load.I'm going to have to DIM the value, and docmd.openform etc...

View 13 Replies View Related

Forms :: Open Form Not In Tab Of MS Access

Jun 3, 2015

How to make application such that only a form is opened (not as a tab in access) just like pop up feature of a form. i have only one form in my application...

View 2 Replies View Related

Forms :: Open A Form Together With Their Values

Dec 5, 2014

I have made a main form(ApplicantList) and another form(ApplicantDetails) for new applicants which the the DataEntry Property set to Yes now my concern is If double click the LastName of FirstName value on the main form I want to popup the second form which has have all there information..

View 10 Replies View Related







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