Combining query and table

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

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
 
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.

Ofer said:
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
Well, I have a table with fields like Quantity Borrowed and Quantity Returned.
Click to expand...
[quoted text clipped - 4 lines]
the QuantityAvailable showed...
How?
Click to expand...
Click to expand...
 
Back
Top