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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form/Subform Problem

Status
Not open for further replies.
matrec

matrec

Technical User
Feb 19, 2005
19
CY
I have a field named 'TransNo' in the MainForm. The subForm is in the Detail Section of the MainForm.

In the footer of the subForm I have another field called 'InvoiceID' and its Default Value is set to [Form]![subForm]![TransNo].

The problem is that, when I start filling the subForm with data, 'InvoiceID' remains blank for the first record. From the second record onwards everything is OK.

I have not managed to solve this problem, though I spent 3 hours trying all sorts of things.

Any hints to solve this irritating problem ?
Thanks
 
Sort by date Sort by votes
I assume that the subform is linked to the main form using common fields. Is this the Transno field?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
699
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
883
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
511
Andrzejek
Andrzejek
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
362
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
377
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top