 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2007Combining query and table
Well, I have a table with fields like Quantity Borrowed and Quantity Returned. I have a query with a field QuantityAvailable which is calculated based on some formula... So, problem is I want to build a subform consists of this table and query together yet user can enter themselves the QuantityReturned and next field is the QuantityAvailable showed... How? Base the Sub form on the Table only, and in the sub form create another text box to display the QuantityAvailable by writing in the ControlSource of it =[Quantity Borrowed ] - [QuantityReturned] Note: In that formula change it so it would be the right field name (in the table) The value in this text box will be updated automatically as you update the value in any of the other fields  SignatureGood Luck BS"D > Well, I have a table with fields like Quantity Borrowed and Quantity Returned. > [quoted text clipped - 4 lines] > the QuantityAvailable showed... > How? Hey! Thanks for the idea... But, I have created the query and appended it in my form. It can works but it cannot automatically update as I enter the value in other fields.Any solution for that? I can't use your idea as I need to join many other tables. >Base the Sub form on the Table only, and in the sub form create another text >box to display the QuantityAvailable by writing in the ControlSource of it [quoted text clipped - 11 lines] >> the QuantityAvailable showed... >> How? |
Reply to this Message |
 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.