Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RecordSource

Status
Not open for further replies.
dannywo

dannywo

Programmer
Feb 25, 2008
1
US
what is wrong with the following code?
Forms![qryCountPriCodesRptCrd1mgr]![Text27].ControlSource = "" = "" & """Total Logs For "" & Forms!frmCal!Combo43 & & strSQLTot """

strSQLTot is a SQL string

 
Sort by date Sort by votes
You can not execute a Sql string like that. Look at Dlookup.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

5imon
  • Locked
  • Question
Using a Dynamic Queary as a Subform RecordSource
Replies
3
Views
176
dhookom
dhookom
lameid
  • Locked
  • Question
Report, replace by Recordsource Field name value...
Replies
3
Views
137
lameid
lameid
mattpem
  • Locked
  • Question
set recordsource of another form before opening it - AND show a specific record
Replies
2
Views
177
MajP
MajP
Eprice
  • Locked
  • Question
Set query recordsource based on forms combo box selection
Replies
3
Views
90
dhookom
dhookom
abenitez77
  • Locked
  • Question
access forms recordsource
Replies
1
Views
28
abenitez77
abenitez77

Part and Inventory Search

Sponsor

Back
Top