Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11131

Re: Access 2003: Query Stopped Referencing Values On Form ?

Show all headers | View raw

On 22/09/2015 21:17:51, "(PeteCresswell)" wrote:
> I have a query that refers to fields like
> [forms]![frmHome]![txtAsOfDate] and
> [forms]![frmHome]![txtTradingAccountID]
> 
> The query has been working for years and years.
> 
> Now, suddenly, it seems to not be seeing those values - running the
> query "Manually", not from VBA.    It doesn't abend, just returns an
> empty result set.
> 
> The fields are there on the form and populated.
> 
> When I clone the query and replace the refs with explicit values, it
> returns the expected result set.
> 
> Anybody else been here?
> 
> Windows 7, SP1.

I vaguely remember something similar, 
so have you checked that txtAsOfDate and txtTradingAccountID are the form’s
field names and not the name of the field’s ControlSource?

If they are OK, have you tried a Compact & Repair?

I can’t remember whether there was a bug in Access, but have you tried
re-installing Access and applying SP3?

Phil

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Access 2003: Query Stopped Referencing Values On Form ? "(PeteCresswell)" <x@y.Invalid> - 2015-09-22 16:17 -0400
  Re: Access 2003: Query Stopped Referencing Values On Form ? Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-09-22 14:24 -0700
    Re: Access 2003: Query Stopped Referencing Values On Form ? "(PeteCresswell)" <x@y.Invalid> - 2015-09-23 12:27 -0400
  Re: Access 2003: Query Stopped Referencing Values On Form ? "Phil" <phil@stantonfamily.co.uk> - 2015-09-23 09:50 +0100
  Re: Access 2003: Query Stopped Referencing Values On Form ? Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-09-23 11:15 -0700
    Re: Access 2003: Query Stopped Referencing Values On Form ? Optimist <v.meldrew@i.do.not.believe.it> - 2015-09-24 09:28 +0100

csiph-web