display "strWhere" parameter 2nd scr text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Situation: from the main screen where you have all the combo boxes & list
boxes to build the (select, filter, and where string). User selects values
and I build the "where" string. I'd like to display the "strwhere" text box
on 2nd scr but with no success yet. Any suggestion? Thanks.

DoCmd.OpenForm "frmMainScr", acFormDS, , strWhere
 
Try add a text box with a control source of:
=[Filter]

I'm not sure how this would display since it seems you are opening
frmMainScr in datasheet view.
 
Thanks for the suggestion but unfortunately it did not work. I do see the
Filter with correct statement but only if I can display it onto the
screen......

Duane Hookom said:
Try add a text box with a control source of:
=[Filter]

I'm not sure how this would display since it seems you are opening
frmMainScr in datasheet view.
--
Duane Hookom
MS Access MVP
--

skk said:
Situation: from the main screen where you have all the combo boxes & list
boxes to build the (select, filter, and where string). User selects
values
and I build the "where" string. I'd like to display the "strwhere" text
box
on 2nd scr but with no success yet. Any suggestion? Thanks.

DoCmd.OpenForm "frmMainScr", acFormDS, , strWhere
Click to expand...
Click to expand...
 
I don't understand. What are your "screens"? Are these forms or the print
preview of a report?
You mentioned a "2nd Scr" but don't further identify it.

--
Duane Hookom
MS Access MVP
--

skk said:
Thanks for the suggestion but unfortunately it did not work. I do see the
Filter with correct statement but only if I can display it onto the
screen......

Duane Hookom said:
Try add a text box with a control source of:
=[Filter]

I'm not sure how this would display since it seems you are opening
frmMainScr in datasheet view.
--
Duane Hookom
MS Access MVP
--

skk said:
Situation: from the main screen where you have all the combo boxes &
list
boxes to build the (select, filter, and where string). User selects
values
and I build the "where" string. I'd like to display the "strwhere"
text
box
on 2nd scr but with no success yet. Any suggestion? Thanks.

DoCmd.OpenForm "frmMainScr", acFormDS, , strWhere
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane after more trials & errors it worked

Private Sub Form_Load()
txtFilter = Me.Filter
Me.cmdEdit.Enabled = True
Me.cmdSave.Enabled = False
Me.cmdCancel.Enabled = False
End Sub

Duane Hookom said:
I don't understand. What are your "screens"? Are these forms or the print
preview of a report?
You mentioned a "2nd Scr" but don't further identify it.

--
Duane Hookom
MS Access MVP
--

skk said:
Thanks for the suggestion but unfortunately it did not work. I do see the
Filter with correct statement but only if I can display it onto the
screen......

Duane Hookom said:
Try add a text box with a control source of:
=[Filter]

I'm not sure how this would display since it seems you are opening
frmMainScr in datasheet view.
--
Duane Hookom
MS Access MVP
--

Situation: from the main screen where you have all the combo boxes &
list
boxes to build the (select, filter, and where string). User selects
values
and I build the "where" string. I'd like to display the "strwhere"
text
box
on 2nd scr but with no success yet. Any suggestion? Thanks.

DoCmd.OpenForm "frmMainScr", acFormDS, , strWhere
Click to expand...
Click to expand...
Click to expand...
 
Back
Top