If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error "You cancelled the previous operation"
Hey I have a combo box programmed to return the numeric value selected in an
another combo box. However when I click on a value that presents itself in my pull down menu in the combo box the form crashes and presents me with the error " Run time error 2001 You cancelled the previous operation". I am then presented with Me.RecordSource = QuerySTR as the error. I dont understand why this the case?? Any thoughts Ladies and Gentleman, -Eamonn |
#2
|
|||
|
|||
Error "You cancelled the previous operation"
Are you sure that QuerySTR is valid at that point? The error message you're
showing is sometimes used incorrectly when there's a reference in a query or domain aggregate function (DLookup, DSum, etc) with an incorrect name in it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Eamonn" wrote in message ... Hey I have a combo box programmed to return the numeric value selected in an another combo box. However when I click on a value that presents itself in my pull down menu in the combo box the form crashes and presents me with the error " Run time error 2001 You cancelled the previous operation". I am then presented with Me.RecordSource = QuerySTR as the error. I dont understand why this the case?? Any thoughts Ladies and Gentleman, -Eamonn |
#3
|
|||
|
|||
Error "You cancelled the previous operation"
solved it myself -jus had an extra quote in my coding from that was not needed
If (Me.Combo56.Value = 0) Then 'AMT CCY QuerySTR = QuerySTR Else QuerySTR = QuerySTR + " and [sheet1].[LCL CCY ORDERED] = '" & Val(Trim(Me.Combo56.Value)) & "'" End If Shoulda been If (Me.Combo56.Value = 0) Then 'AMT CCY QuerySTR = QuerySTR Else QuerySTR = QuerySTR + " and [sheet1].[LCL CCY ORDERED] = " & Val(Trim(Me.Combo56.Value)) & "" End If "Eamonn" wrote: Hey I have a combo box programmed to return the numeric value selected in an another combo box. However when I click on a value that presents itself in my pull down menu in the combo box the form crashes and presents me with the error " Run time error 2001 You cancelled the previous operation". I am then presented with Me.RecordSource = QuerySTR as the error. I dont understand why this the case?? Any thoughts Ladies and Gentleman, -Eamonn |
#4
|
|||
|
|||
Error "You cancelled the previous operation"
Ye seems cool no problems with testing,
Regards, Eamonn "Douglas J Steele" wrote: Are you sure that QuerySTR is valid at that point? The error message you're showing is sometimes used incorrectly when there's a reference in a query or domain aggregate function (DLookup, DSum, etc) with an incorrect name in it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Eamonn" wrote in message ... Hey I have a combo box programmed to return the numeric value selected in an another combo box. However when I click on a value that presents itself in my pull down menu in the combo box the form crashes and presents me with the error " Run time error 2001 You cancelled the previous operation". I am then presented with Me.RecordSource = QuerySTR as the error. I dont understand why this the case?? Any thoughts Ladies and Gentleman, -Eamonn |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PLEASE HELP! Regarding You cancelled previous Operation | JJames | Using Forms | 2 | September 19th, 2005 02:00 PM |
subquery or previous record question | SAm | General Discussion | 4 | August 18th, 2005 05:11 PM |
Run-time Error 2001: You cancelled the previous operation | Andy | Using Forms | 7 | August 3rd, 2005 09:05 AM |
Compatibility issues of Office 2003 with previous versions? | Orlando Acevedo | General Discussions | 1 | June 24th, 2004 04:23 PM |
Access 2000 - You Cancelled The Previous Operation | Mark C | General Discussion | 5 | June 8th, 2004 09:47 PM |