Consecutive Number in a Form

L

ldiaz

Hello all


I have a form named:1_Broker_frm and a subform named:2_Control_subform
both (form and subform) are linked as follow:

Link Chield Fields: (ID) this is the first column in subform
(2_Control_subform) and is set as Number
Link Master: (ID_Broker_ID) this is the first column the form and is set as
Autonumber

I have another field (Item_No) in subform where my concern is:

I want in the first row in field: (Item_No) like 1, second row 2, and third
3 and so on. but take in mind that every new record in ID_Broker_ID then
subform needs to start again in 1,2,3

please help and post if you need more information to help me

Thanks in advance
 
Top