I have a form where the record source is a linked table. The primary key is the Cust_Ord_ID and Line_No.
The main form (Enter_RMA) has a subform (Ord_Line). The subform is the form where the data source is a linked table. Right now users fill out the main form and then move onto the subform. On the subform they have to manually type in 1 in the line_no and then the rest of the order. If there are 2 items being ordered then another line has to be added and the user has to enter in 2 in the next line_no. Is there anyway to get that line_no field to number automatically?
I can't change the the field type since it's a linked table. Any ideas? or i'll let it the way it is and hope the users can count correctly.
The main form (Enter_RMA) has a subform (Ord_Line). The subform is the form where the data source is a linked table. Right now users fill out the main form and then move onto the subform. On the subform they have to manually type in 1 in the line_no and then the rest of the order. If there are 2 items being ordered then another line has to be added and the user has to enter in 2 in the next line_no. Is there anyway to get that line_no field to number automatically?
I can't change the the field type since it's a linked table. Any ideas? or i'll let it the way it is and hope the users can count correctly.
