Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / March 2006

Tip: Looking for answers? Try searching our database.

New Parameter values (from Form) not being picked up by Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Toulousse - 30 Mar 2006 01:39 GMT
Hi,

I've coded a form which calculates and populates a text box on a form.  To
be clear, data entered into the Textbox is not done manually it is calculated
on the AfterUpdate event on other fields in the form.

I have another command button on the same form which then loads a query, the
query refers directly to the "calculated" Textbox on the form as part of the
query's criteria.  However the query does not recognise the value entered.  
It will work if I click inside the Textbox then run the query!!.

I've tried using Refresh, Requery, DoEvents.... even Repaint...  Non seem to
work.

Any help would be greatly appreciated.

Thanks in advance.
[MVP] S.Clark - 30 Mar 2006 18:27 GMT
What do you mean by clicking the command button 'Loads' the query?
What is the value in the query that should recognize the calculated field?

Post your command button code and the SQL.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

> Hi,
>
[quoted text clipped - 17 lines]
>
> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.