Full Version: Error 3360 When Form Opens
UtterAccess Forums > Microsoft® Access > Access Forms
TimTDP
I have a form with a subform
When the main form opens the following code runs (form On Open event):
CODE
intSupplierReturnId = 0
intSupplierId = 0

Form_Current

The form "On Current" Event contains the following code:
CODE
If intSupplierReturnId = 0 And intSupplierId = 0 Then
     Me.RecordSource = "Select * from qryReturnsToSupplier WHERE 1 = 0"
     Me.frmProductReturnToSupplierProducts.Form.RecordSource = "Select * from qryReturnsToSupplierUnallocated WHERE 1 = 0"
     GoTo Exit_Procedure
End If

Oget an error 3360 - Query is too complex in the code: Me.frmProductReturnToSupplierProducts.Form.RecordSource = "Select * from qryReturnsToSupplierUnallocated WHERE 1 = 0"
I can open qryReturnsToSupplierUnallocated without any problems
I want to run the above code to open the forms without any data.
how do I prevent the error?
Many thanks in advance
theDBguy
Hi Tim,
Just a quick note, you don't need to call the Current event in the Open event of the form because it will fire anyway when the form opens.
Just my 2 cents... 2cents.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.