Auto Numbers on Forms records; Display + Save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a form bound to “DataSub†table. On the same form some un-bound
controls, which will save the information to DataMain table. DataMain table
have fields like DocumentNo, FromDate and EndDate. In DataSub Table fields
are txtDocumentNo, txtFromDate, txtEndDate, SrlNo , ProductCode and so on (I
know here both date fields are not required). On the form before update of
ProductCode I’m writing code
Me.txtDocumentNo=DocumentNo
This will bring the DocumentNo to this control and will save the same number
under the DocumentNo field in the DataSub Table. Till here everything working
fine. Now I forced to input serial number & save the same serial number under
the field SrlNo.
How I will manage this? If document No 706, which have 4 records, I want
Numbers 1 to 4 and save the same in subtable. Another if 707 is having 3
transactions then it must start from 1 to 3 and save it. Please help in this
regard.

Also, records selector should show the 1 record only, what I mean, I don’t
want to display total record numbers in down window.
 
I don't understand. What are you trying to do here? Enter data about a
subtable record and then have it append the corresponding record on to the
main form? How does it know that there are 4 records?
 
Rob Oldfield said:
I don't understand. What are you trying to do here? Enter data about a
subtable record and then have it append the corresponding record on to the
main form? How does it know that there are 4 records?
Click to expand...
 
Back
Top