RLN wrote:
RE: Access 2003
I have a SQL variable (strSQL1 dimmed as String) that gets built using
Select Case logic. The first half of strSQL1 is etched in stone no
matter what.
The 2nd half of strSQL1 (the condition) is built depending on which
option button is chosen:
For option 1, I add "Condition X" to the end of strSQL1.
For option 2, I add "Condition Y" to the end of strSQL1...etc.
When the Select Case logic is completed strSQL1 is built and I then need
to launch a form in Datasheet mode using strSQL1 as my data source.
Can this be done?
*** Sent via Developersdex http://www.developersdex.com ***
I suppose you could launch and change the source.
DoCmd.OpenForm "FormName", , , , , , strSQL1
Now in the OnOpen even you could do
If Not IsNull(me.openargs) then Me.Recordsource = Me.OpenArgs
But I don't see the necessity because the table info isn't
changing...just the filter. Let's say you simply make strSQL1 the
conditional then pass the filter. Ex:
strSQL1 = "customerid = 123".
DoCmd.OpenForm "FormName", , , strSQL1
and this will open it to filtered records where customerid = 123
Once in a form, you could do things like this
Me.Filter = "CustomerID = 123"
Me.FilterOn = True
Powerful
http://www.youtube.com/watch?v=YhrLBrDzj5Q