G
Guest
Yesterday, I had a nice bit of code in a form, virtually the same as given by
Access (2002) help, that set a forms recordsource to find a particular record.
Nothing fancy in the code:
strSQL = "Select * from qRefCallHeader where cabreferrals.ubrn = '" &
Me.txtUBRN & "' "
Me.RecordSource = strSQL
(qrefcallheader is a query)
followed by:
a select case statement using me.recordset.recordcount
- I want to make sure there is only one record.
Worked fine yesterday.
Today wahtever I put in the strSQL statement, even if just the name of a
table: Or even if I just do
Me.RecordSource = "users"
me.recrodset.eof, me.recordset.bof are both true, and
me.recordset.recordcount is 0 (zero).
PLEASE: Any idea at all where I might look to find out why it isn't working
today???
I have done some changes, but am at a loss.
Access level is 10.6771.6804 SP3, and I have compacted/repaired and
compiled the application.
If I print the strSQL string in the debug window, copy and paste it into a
new query SQL window and run it, it does find the record OK. As far as I can
tell, "me.recordsource =" has just stopped working overnight
Thanks
Access (2002) help, that set a forms recordsource to find a particular record.
Nothing fancy in the code:
strSQL = "Select * from qRefCallHeader where cabreferrals.ubrn = '" &
Me.txtUBRN & "' "
Me.RecordSource = strSQL
(qrefcallheader is a query)
followed by:
a select case statement using me.recordset.recordcount
- I want to make sure there is only one record.
Worked fine yesterday.
Today wahtever I put in the strSQL statement, even if just the name of a
table: Or even if I just do
Me.RecordSource = "users"
me.recrodset.eof, me.recordset.bof are both true, and
me.recordset.recordcount is 0 (zero).
PLEASE: Any idea at all where I might look to find out why it isn't working
today???
I have done some changes, but am at a loss.
Access level is 10.6771.6804 SP3, and I have compacted/repaired and
compiled the application.
If I print the strSQL string in the debug window, copy and paste it into a
new query SQL window and run it, it does find the record OK. As far as I can
tell, "me.recordsource =" has just stopped working overnight
Thanks