Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 2nd, 2003, 07:50 AM
GaryN GaryN is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 4 GaryN User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Requery Dilemma

In Access2000 - frontend, SQL - backend, I have a form and a subform. The
form contains data specific to an order that we received inclusive of a
DueDate. (The DueDate is automatically generated once certain criteria have
been met.) There are certain instances when the DueDate has to be changed.
Therfore, I created a command button which takes the user to the subform.
The subform allows the user to change the DueDate + / - a specified number
of days. The enter a reason why the date is being changed then exit the
subform and return to the main form which is still open.

My dilemma is that once I exit the subform, I need the main form to update
the DueDate with the new date established in the subform, and I don't want
the user to have to search to locate the job they just changed. I believe
this can be done as a Re-query, but my knowledge of re-querying is limited.
Is the requery done in the sub-form or the main form? What is the structure
of the code used? Please help.

Thanks
Rookie

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Requery Dilemma


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT