R
RNUSZ@OKDPS
I need to keep track of record sequence numbers in Access 2003 form/subform
in entry mode as well as update mode. I want to be able to scroll forward
and backward through data, as well as add new records in update mode to this
same form and keep track of all record sequence numbers, what has to be done
to do this, is there someone who could assist in the VB code side of it.
Primary Table name is TST_FR_CASE_RECORDS, secondary table is
TST_FR_CASE_OTHERS, both tables are linked master & child through primary key
field of two joined fields. CASE_NUM_YR and CASE_NUM ( 2004 100 ) for a
primary key of 2004100. Secondary table has additional key field of SEQ_NUM.
Parent form name is FR_CR_U and the subform added to a tab page on this form
is named sb_FR_ADD_OTHERS_U. Subform Sb_FR_ADD_OTHERS_U has field
txt_CASE_NUM_YR that gets populated via parent form Case_Num_Yr field and
field txt_CASE_NUM that gets populated via parent form CASE_NUM field. Sub
form also has txt_SEQ_NUM which catches the record sequence number for the
records in secondary table. Subform also has unbtxt_PREV_CASE_NUM_YR field,
unbtxt_PREV_CASE_NUM field, unbtxt_PREV_SEQ_NUM field, that I wanted to use
to display previous record ID's as user flowed forward and backward through
table data. Upon user clicking ADD NEW RECORD command button, subform clears
and allows user to add additional records to same group of records, thus
extending number of records belonging to primary key group. What do I have
to do to keep track of record sequence numbers, any chance of assistance on
VB code example.
When responding, please respond to this email when possible. I'm using
Microsoft Office professional 2003 with Access 2003 front-end and updates
applied to IBM Mainframe DB/2 tablespace. Sample of the form can be sent if
needed, but will need email address of those who wish to assist.
Thanks in advance.
in entry mode as well as update mode. I want to be able to scroll forward
and backward through data, as well as add new records in update mode to this
same form and keep track of all record sequence numbers, what has to be done
to do this, is there someone who could assist in the VB code side of it.
Primary Table name is TST_FR_CASE_RECORDS, secondary table is
TST_FR_CASE_OTHERS, both tables are linked master & child through primary key
field of two joined fields. CASE_NUM_YR and CASE_NUM ( 2004 100 ) for a
primary key of 2004100. Secondary table has additional key field of SEQ_NUM.
Parent form name is FR_CR_U and the subform added to a tab page on this form
is named sb_FR_ADD_OTHERS_U. Subform Sb_FR_ADD_OTHERS_U has field
txt_CASE_NUM_YR that gets populated via parent form Case_Num_Yr field and
field txt_CASE_NUM that gets populated via parent form CASE_NUM field. Sub
form also has txt_SEQ_NUM which catches the record sequence number for the
records in secondary table. Subform also has unbtxt_PREV_CASE_NUM_YR field,
unbtxt_PREV_CASE_NUM field, unbtxt_PREV_SEQ_NUM field, that I wanted to use
to display previous record ID's as user flowed forward and backward through
table data. Upon user clicking ADD NEW RECORD command button, subform clears
and allows user to add additional records to same group of records, thus
extending number of records belonging to primary key group. What do I have
to do to keep track of record sequence numbers, any chance of assistance on
VB code example.
When responding, please respond to this email when possible. I'm using
Microsoft Office professional 2003 with Access 2003 front-end and updates
applied to IBM Mainframe DB/2 tablespace. Sample of the form can be sent if
needed, but will need email address of those who wish to assist.
Thanks in advance.