Open Specific Form From Combo Box

Nov 12, 2005

I have a form with a subform which has a lookup table (combo box) as a field. I want to be able, when I select a certain item in the lookup to have it automatically open a form. e.g. A field called insurance class - I select motor, I want the motor details form to open. If I select Fire, I want it to open the fire form and so on. I have already created the forms. Please help!

View Replies


ADVERTISEMENT

Forms :: Run Specific Queries And Open A Report Using Combo Boxes

Jul 30, 2013

I have a form which runs specific queries and opens a report using combo boxes, these work perfectly fine if I just try to run them in the form. I have put the form into a navigation form and if I try to run the same query I get parameter queries popping up instead of just running the query and opening the report.

View 2 Replies View Related

Open A Specific Form

Nov 2, 2006

I have a table that depending on a certain field in that table it will be able to open a specific form.

In other words I have multiple forms but only want a specific form opened when accessing a record if that record has a field with certain criteria

if that makes any sense

thanks

View 1 Replies View Related

Open Specific Form

Jan 3, 2007

I have 2 forms one named "View" and the other "edit" on the form "view" the final user cannot edit any field as set from the form properties the form "edit" has no restrictions, what I need is to put a push button on the form "View" that will open the form "edit" showing the same record as on the form "View"
Hope I explained my problem :)

View 5 Replies View Related

Open Form To Specific Tab

Jun 19, 2012

I have an input form that opens another second input form. The code below opens the form to the correct record.

However, the form that I open has a bunch of tabs on it, and I want to open the specific record right to the tab "Technology_Page". Any way that I might be able to do that right from this statement?

Code:
DoCmd.OpenForm "ProjectDetailsActive", acNormal, , "PPID = " & Me!PPID

View 1 Replies View Related

How To Open A Form At Specific Record?

Feb 2, 2005

Hi,

I want to open a new form which is similar to the form it will be opened from. Only difference is the new form I want to open is designed for printing purposes.

I'd like to access the this new form by hitting a button that opens the print form for a user given order number. Any ideas if this is possible? Thanks

View 1 Replies View Related

Open A Form And A Subform On A Specific Record

Mar 7, 2006

I am trying to open a single form with a single subform with a command button. I would like to open the form with the subform on a specific record but I am not entirely sure how to do this, I was wondering if someone had any advice that could help.

View 2 Replies View Related

Open A Specific Excel Doc From Access Form

Jul 5, 2006

I know how to create a command button to open excel, but is there a way to create a command button to open a specific excel file?

View 1 Replies View Related

Forms :: Open New Form With A Specific ID (or Name) Filled In

Feb 4, 2014

(MACROS ONLY)I am looking for a way to open a form in order to add a new record. The idea is that I open up the form with a MemberID and possibly the name already filled in on the relevant form. It is merely for ease of use regarding the user.

I have got as far as opening the the new entry form. I just need to pass the MemberID into the relevant field. If I use the wizard it is just finding a record of a pre-filled entry.

View 7 Replies View Related

Modules & VBA :: Go To A Specific Record In Open Form

Mar 27, 2014

I have a form that is opened as hidden when my startup form loads. Data gets entered into it from other forms so whenever I switch records the hidden form needs to be opened to the matching record.

To accomplish this, I have been using the DoCmd.OpenForm in the OnCurrent event with the WHERE clause matching the PK/FK. I have had no luck with the SearchFor method.

It seems silly to have to keep reopening a form to go to a specific record when the form is always open already. Plus, I am wondering if it is affecting the forms' load times.

Is there a better way to do this (there must be)?

View 1 Replies View Related

Forms :: Open Form With Specific Subform

May 16, 2014

Basically I have a database that records commitments for clients. The user can go a client form, and within that form there is a subform which shows each expenditure commitment for that person (wihtin the subform there is also another subform that shows all income attached to each commitment). The user can use the Next and Previous buttons to navigate through the expenditure commitments (and the same if they want to navigate through the income commtiments within each expenditure commitment).

If you double click on any specific commitment whithin any part of the subform, then the expenditure commitment form (or the income commitment form if it is an income one) opens to allow the user to change stuff.

My database is set up so that each time a form opens the previous form closes. So when the user has the commitment form open and clicks close, the client form will re-open. My issue is that is always goes back to showing the very first commitment and the user then has to navigate back through till they find the one they have just updated.

What I would like to be able to do is when the user closes the commitment for that the client then the form opens up with the specific subform on the screen that they have just changed.The code I currently have written on the Close command of the Commitment is as follows:

Code:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTotalCommitmentsbyClient
stLinkCriteria = "[FrameworkID]='" & Me![FrameworkID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmCommitments"

I essentialy just need the bit that would also say show the subform (which is called subfrmComms2) where the commitmentID = the commitment ID on the Commitment form.Now just to really complicate matters, I would also like this to happen if someone has the Income Commtiment form open and they close it, only the Income Commitment subform is actualy a subform of subfrmComms2 (above), but equally the income commitment form has within it the Expenditure ID, the Income ID and the FrameworkID.

View 3 Replies View Related

Forms :: Open A Form Of A Specific Record?

Jan 26, 2014

1. I have created a button in a switchboard with embedded macro:-

Close Window
OpenForm (Form name: frmCustomerFind)

2. I have created a form "frmCustomerFind), in which I can select a customer name in a combo box named "CustomerName".

a. The row source: SELECT [tblCustomer].[CustomerID],[tblCustomer].

[CustomerName] FROM tblCustomer ORDER BY [CustomerName];

b. After Update Macro:

Open Form (Form name: frmCustomer)
SearchForRecord (Object Type: Form Object Name: frmCustomer
Record: First Where Condition = "[CustomerID]=" & Me.CustomerID

At the end, the form "frmCustomer" does open but not go to the record I want. It goes to the first record instead. (The frmCustomer has the "CustomerID" and "CustomerName" fields).

View 1 Replies View Related

Forms :: Open Form To Specific Record

Mar 31, 2015

Need to open a form to a specific record.Ive done the command button wizard that opens the form to a specific record but but that brings up the form with the filtered button showing.I've tried to put the formula into the filtered section but that doesn't work.I just want to be able to open the form to the specif record and then be able to navigate to other records if required (without aving to press the filtered button)

View 1 Replies View Related

Forms :: Open Tab In Form To Specific Record

Feb 9, 2015

Currently, I have a form with tabbed pages in it. The second tab, I have a subform inserted into it. I have a completely separate form that looks through records. I want to be able to click on a record from the separate form and open the Main tabbed form, to the second tabbed page, to a specific record. Currently I have:

Private Sub Form_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_Main_Data_Entry"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Forms![frm_Main_Data_Entry]![pgAgreement].SetFocus
End Sub

Which opens up to the tabbed page just fine. but I can not figure out how to get to a specific record.

Also, the subform in the tabbed page, doesn't have the same controls as the Main tabbed Form itself, so when I add something like:

strCriteria = "Agreement_Number = " & Me.Agreement_Number

it won't work because it is not reading from the subform in the tab, rather its reading from the main form controls.

View 1 Replies View Related

Forms :: Open Sub Form To A Specific Record

Dec 31, 2014

I have a form that lists a number of orders (list box).

I have another form that has customer details as the main form and the order as a sub form and then another sub form for items....

How can I open the sub form to a specific record? ie I want to view order 14?

View 4 Replies View Related

Forms :: Open Form To Specific Record

Nov 5, 2013

No I know this one has been done, and I have a form with a button that this works on. Here is my problem. I have a list of parts in a continuous form, I added a button to open that specific record in a detail view and it works just fine. I used an open form macro and put in the criteria

="[Description]=" & "'" & [Description] & "'"

I have tried to use this similar procedure for another form, it however has two subforms in it and I get a data type mismatch in criteria exception error. I suspect that it has something to do with the subforms but am not sure.

View 13 Replies View Related

Modules & VBA :: Open Form And Setfocus To Specific Control

Feb 24, 2015

I have a from that has information icons that opens a separate form to support users make the right choice on a form. With each information form users are able to choose "Yes" or "No" and then it returns them back to the form they started. I am having trouble setting the focus to the control the user original left the form from.

Form A
Control 1
Control 2
Control 3

Form B
Information for Control 1

Form C
Information for Control 2

Form D
Information for Control 3

For Forms B - C I would like the form to close, open Form A and then set focus to the control that the form was providing information for.For example, if you are on Form C and you make a decision, I want Form C to close, Form A to open and focus to be set to Control 2.

Code:
Private Sub image5_Click()
Dim sWHERE As String
Criminal_Background.Value = "Yes"

[code]...

View 8 Replies View Related

Forms :: Open Specific Record In Form From Login

Aug 20, 2013

I have been trying for weeks to get my login form to open up to a specific record on the mainform. I have built a form out of my Employee tbl (mainform). The table stores (ID,Name, password, EmpNumber ect.) I built a subform in that allows the user to type in the number of overtime worked on a paticular day. I have disabled the navigation on the main form so users can't advance to the next user but have enable the natigation on the subform so a particular user can advance to the next week of available overtime to input data.The goal is to get user login form to display a particular record on the main form and open a different form in the user is a supervisor.

Option Compare Database
Private intLogonAttempts As Integer
Private Sub cmdExit_Click()
DoCmd.Quit
End Sub
Private Sub cmdLogin_Click()

[code]...

'If User Enters incorrect password 3 times database will shutdown

intLogonAttempts = intLogonAttempts + 1
If intLogonAttempts > 3 Then
MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical, "Restricted Access!"
Application.Quit
End If
End Sub

View 1 Replies View Related

Forms :: Open Up A Form To Specific Records In Its Subform?

Aug 6, 2014

I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done?

Using:
Win 7
Access 2010

View 14 Replies View Related

Forms :: Open Another Database Form On Specific Record

Jan 20, 2015

I'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open.

Code:
Private Sub btnDetail_Click()
DoCmd.OpenForm "fJob", , , , , , Me.Name
Forms![fjob]![txtJobNumber] = Forms![fJobAlphabetic]![fJobAlphabeticSub].Form![JobNumber]
End Sub

View 2 Replies View Related

General :: Open Tabbed Form To A Specific Page?

Jan 21, 2014

Can I open a tabed form to a specific page?

If I'm in the form I can move focus by using

Me.[Page 12].SetFocus

but when opening using that code produces and error Page not available?

View 3 Replies View Related

Modules & VBA :: Code To Open A Form To A Specific Record

Sep 4, 2014

I am using a datasheet view with dbl click code to open a form to a selected record. I was able to use pbaldy's code and it worked perfectly.

DoCmd.OpenForm "Asset Status", , , "[Project Number] = '" & Me.Project_Number & " ' "

Then I realized I really want to be able to go to other records after I have gone to this form and tried this:

Dim rs As Object
Dim lngBookmark As Long
'set variable to the current record
lngBookmark = Me.Project_Number
'open new form

[code]....

But to no avail. Project_Number is a text field.

View 12 Replies View Related

Open Form And Go To Specific Record Based On Variable

Jun 9, 2010

I have two tables and two separate forms. [ID] is the link between them. (I cannot do a subform in this case).

Form1 displays 3 records

Have control button that goes to Form2 where [id] = NumID (NumID is "long" variable)

Have control button on Form2 to go back to Form1. It needs to go to the same record it came from. I don't want use a where clause (e.g., where [id] = [id]). This works, but the form1 is now filtered. I need all records available in Form1, but I want to go to the record it was on when the button was clicked to go to form1

Example:
Form1, record1, ID=30
Form1,record2,ID = 35
Form1,record3,ID = 40

Select record3,ID=40, then click on button to go to form2 (has where clause where ID=40).
Form2 is filtered and is correct.

Click on button to go back to form1. No Filter. It goes to 1st record (record1,ID=30). I need all records displayed, but need to be on record2,ID=35.

View 4 Replies View Related

Forms :: Open Form And Show Specific Data To Display

Apr 1, 2013

I have a form and this form shows some values from one table. One of the fields named as Key. I want to open another form and show the record that has the same value as Key.

I am able to make this with filter but the form opens and when the user navigates the record, it creates a duplicate value in related table.

I want to open form and find specific data to display and then stop at this record.

View 1 Replies View Related

Forms :: Datasheet Form - Click Specific Record And Open

Apr 10, 2013

I have created a Datasheet Form which when opens shows lots of records. I was looking to see if there was a way that if i clicked on a specific field name within a record it would open a new form with all the information of that record only.

View 5 Replies View Related

General :: Click On Datasheet To Open Specific Record In A Form

Jul 16, 2012

I have two forms. One is a datasheet. One is a form with a default view of Single Form (which contains combo boxes).I want to have the user select (click) on a record in the datasheet and have the second form open to that record. The datasheet form acts as an advanced search on two title fields.I tried the open form macro but I dont know how to have to second form open to a specific record.

View 9 Replies View Related







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