sree4dream
New member
- Local time
- Yesterday, 16:14
- Joined
- Jul 18, 2019
- Messages
- 3
Hi all,
Can you help me solve this
In my main table I have 20 separate entry for for serial number ie (Serial 1, Serial 2... Serial 20) (Data type in Number)
also
In my main table I have 20 separate entry for for quantity ie (Quantity 1, Quantity 2... Quantity 20)(Data type is Number)
My data entry form has both serial (1 - 20) and quantity (1-20)
I need serial number column to be auto inserted in form as I change value for quantity ie (Serial NO 1 =1 (Auto); When I change value for Quantity No 1; By default Quantity 1 value is =0
Serial No column must auto update itself if i delete a quantity ie (Serial No 2 =null, when quantity 2 = 0 & Serial 3 gets value AS 2 )
looking forward to a VBA or Control Source Expression solution
Can you help me solve this
In my main table I have 20 separate entry for for serial number ie (Serial 1, Serial 2... Serial 20) (Data type in Number)
also
In my main table I have 20 separate entry for for quantity ie (Quantity 1, Quantity 2... Quantity 20)(Data type is Number)
My data entry form has both serial (1 - 20) and quantity (1-20)
I need serial number column to be auto inserted in form as I change value for quantity ie (Serial NO 1 =1 (Auto); When I change value for Quantity No 1; By default Quantity 1 value is =0
Serial No column must auto update itself if i delete a quantity ie (Serial No 2 =null, when quantity 2 = 0 & Serial 3 gets value AS 2 )
looking forward to a VBA or Control Source Expression solution