Search results

Don't know if that did it, but did: Me.txtPropertieID = Me.Parent.txtPropertieID Me.Parent.txtPMCID = Me.txtPMCID Me.txtMCAddress1 = Me.txtMortgageCompany.Column(2) Me.txtMCAddress2 = Me.txtMortgageCompany.Column(3) Me.txtMCCity = Me.txtMortgageCompany.Column(4) Me.txTMCState =...

I will try this, but this is all through my database as there is 96 forms, 220 reports, and 17 modules that may have this information in it, so before I go and change this, can you tell me more as to why I need to do this. Also, this was a Access 2000 db that was upgraded to 2003 recently. Does...

You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162) You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to declare the variable as a Variant, and then try the operation again. Here's the...

As stated in title - I am using 2003. The problem in not in the NotInList code, but thanks for the information: Private Sub txtMortgageCompany_NotInList(NewData As String, Response As Integer) Dim strMessage As String Dim db As Database Dim rs As Recordset strMessage = "Are you sure you want...

Sorry - This is on a command button (close). Main form - frmProperties Subform - frmPropertiesMortgageCompanies Subform Control - txtMortgageCompany txtMortgageCompany_NotInList opens frmMortgageCompanies. after filling out the information and click on the Close button get ""you must save the...

I had the following code in 2000. Recently updated to 2003. Now when you enter information you get "you must save the current field before you run the requery action" If IsLoaded("frmProperties") Then...