C
Cagey
I still need help w/this please; reposting...
Goal:
If this selection or if click on selection (highlighted line
choice/which ever selection change)
w/in query's combo dropdown list box (on Switchboard), then Open in
Datasheet View,
the specific underlying record's Row... showing all columns or selected
columns.
* For that row's record only, or for all Xs (same type), or for
the whole data sheet (all records... includes all types then), but
focus still opens to specific selection.
- Do I need to 1st create separate dataview reports for each Type (X,
Y, or Z) to point to as record source...
(using some type of argument from my thoughts -below my current Sub)?
- Or do I enter something in the queries "Criteria:" field?
- Is there anyone that knows how to do this & explain using correct
syntax, in simplest clear terms?
So far:
Private Sub QueryQ_Click() 'record source is query
If Me.[TableNameABC]![FieldX] Then
Me.[FieldX:Yes] = "x"
End If
If Me.[TableNameABC]![FieldY] Then
Me.[FieldY:Yes] = "y"
End If
If Me.[TableNameABC]![FieldZ] Then
Me.[FieldZ:Yes] = "z"
End If
-- My working Sub currently ends here. Following includes possible
pieces of code to accomplish what I'm trying, but am not sure how to do
this, if it's possible. I'm sure I've been able to do this function as
a user before, but not sure if it was Access or vb or what.
If [Table NameABC]![Query] And Me.[XType:Yes] = "x" Then
GoTo Me.[QueryQ] And Me.[Table NameABC]![Unique_ID] = OpenRecord,
acPreview
'Show Me.RecordSource = 'Me.Reports -(if this then 1st create
separate dataview reports for each Type)?
'Me.Visible 'Me.ViewsAllowed 'Me.SetFocus
'Me.RecordSourceQualifier?? 'Me.RecordsetType
'Me.PopUp 'Me.OpenArgs ?? 'Me.KeyPreview
'Me.HasModule 'Me.GoToPage 'Me.FilterOn 'Me.OnOpen
'Me.OnGotFocus
'Me.OnCurrent *columns, rows fields where Me.X:Yes = x
'or show where X Option & Y Option are both checked (from Option
buttons... as grouped on Switchboard)???
'Me.CurrentRecord
'Else Me.SelectionChange
End Sub
Hope this is clear. THANKS in advance!!
Goal:
If this selection or if click on selection (highlighted line
choice/which ever selection change)
w/in query's combo dropdown list box (on Switchboard), then Open in
Datasheet View,
the specific underlying record's Row... showing all columns or selected
columns.
* For that row's record only, or for all Xs (same type), or for
the whole data sheet (all records... includes all types then), but
focus still opens to specific selection.
- Do I need to 1st create separate dataview reports for each Type (X,
Y, or Z) to point to as record source...
(using some type of argument from my thoughts -below my current Sub)?
- Or do I enter something in the queries "Criteria:" field?
- Is there anyone that knows how to do this & explain using correct
syntax, in simplest clear terms?
So far:
Private Sub QueryQ_Click() 'record source is query
If Me.[TableNameABC]![FieldX] Then
Me.[FieldX:Yes] = "x"
End If
If Me.[TableNameABC]![FieldY] Then
Me.[FieldY:Yes] = "y"
End If
If Me.[TableNameABC]![FieldZ] Then
Me.[FieldZ:Yes] = "z"
End If
-- My working Sub currently ends here. Following includes possible
pieces of code to accomplish what I'm trying, but am not sure how to do
this, if it's possible. I'm sure I've been able to do this function as
a user before, but not sure if it was Access or vb or what.
If [Table NameABC]![Query] And Me.[XType:Yes] = "x" Then
GoTo Me.[QueryQ] And Me.[Table NameABC]![Unique_ID] = OpenRecord,
acPreview
'Show Me.RecordSource = 'Me.Reports -(if this then 1st create
separate dataview reports for each Type)?
'Me.Visible 'Me.ViewsAllowed 'Me.SetFocus
'Me.RecordSourceQualifier?? 'Me.RecordsetType
'Me.PopUp 'Me.OpenArgs ?? 'Me.KeyPreview
'Me.HasModule 'Me.GoToPage 'Me.FilterOn 'Me.OnOpen
'Me.OnGotFocus
'Me.OnCurrent *columns, rows fields where Me.X:Yes = x
'or show where X Option & Y Option are both checked (from Option
buttons... as grouped on Switchboard)???
'Me.CurrentRecord
'Else Me.SelectionChange
End Sub
Hope this is clear. THANKS in advance!!