Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

When subform is blank

Status
Not open for further replies.
Tekay

Tekay

MIS
Oct 25, 2002
24
US
How can I force a 0 qty in a subform that is blank?
I use the main form with field name: TOTAL SHIPPED and a subform to capture part shipments as they occur and show a subtotal in my main form.
Trouble is records without SHIPPING details show in my reports as BLANKS. I need to get a number so that my report will calculate Balance to ship. which is qty-total shipped.

Thanks
p.s. I only know macro programming..

 
Sort by date Sort by votes
Please help..I am stuck at this last juncture to finish my project...
Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
645
Kennelbloke
Kennelbloke
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
2K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
446
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
583
TrekBiker
TrekBiker
MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
448
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top