Search results for query: *

That works Great, just what I needed. I have been searching for the right code for this for awhile Thanks again.

I have tried a couple ways to move through forms with the current record opening in the next form and closing the previous form. Using this code: DoCmd.OpenForm "Contacts", , , "[ContactID] = " &ContactID DoCmd.Close acForm, "Customers" Single forms work fine this way. The problem is, when I...

Sorry, I still haven't quite got it. I'm going from "Customer Phone list" (Continuous form] to "Contacts" (Single Form) I can go ther fine with this Dim stDocName As String Dim stLinkCriteria As String stDocName = "Contacts" stLinkCriteria = "[ContactID]=" & Me![ContactID]...

Not Sure I Understand Here is how I have it now Continuous Form Code to open Contacts; Private Sub CompanyName_DblClick(Cancel As Integer) On Error GoTo Err_CompanyName_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Contacts" stLinkCriteria =...

I am using a continous form to go to other detailed forms. I have the continuous form close so updated field are shown when I return. The problem is, it returns with all records showing in it's original sort order. I have also tried this code, Dim stDocName As String Dim stLinkCriteria...

That Worked Perfectly. Thanks. That helps me to finish other areas too. Thanks again

I'm trying to reference a field in a Subform to set ctriteria in a Combo Box Query. I'm trying: [Forms!]![Orders]![subInfo1Customers]![CustomerID] Where Am I going wrong

The control for the ID is in a subform "Orders" based on a query and The name is not available. I tried adding the product table to the query, to get the name but got poor results trough the rest of the subform.

This is probably so simple, but I'm brain dead now. A number of places I have an ID number showing where I'd like to have the name. Easy If I use a combo box, but I just what a text box to get the name corresponding to the ID number. Example have a form (Orders) with a (Order Detail)subform...

Text and a field size of 50

I have had this expression denoting a IDNumber =[StudentID] & Left([FirstName],1) & Left([LastName],1) & [InstClID] Now It has stopped working Get Runtime Error 2113 This is the code but I get a #Name? in the text box containing the expression. Private Sub InstructorPP_DblClick(Cancel As...