Kindly find the attachment 17dpo.zip
thatsort issue is resolved now i want when user should clickon grid1only item_code, product_name, unit should come and cursor should
be at quantity column so that user put quantity on that cell for material requisition.

kindly find 17dpo.zip

FlexGrid is not editable Grid. you cannot edit MSFlexgrid/MSHFlexGrid directly. u have to use another TextBox control to display covering that cell and after data is input and validated in that text box, it can be updated to the Grid.

Instead of using 2 grids, u can use a DataGrid which can Edit, Delete, Update rows dynamically without the need of any extra control.

U actually want to add a list of items with their quantities specified for the MR. Why do you want to take 1 grid, populate it with all items, then select one by one and populate them to another grid. a very tedious task.

Instead if the Grid is initially empty with only headings and an empty row say, when you enter the first column all Product Codes are dropped down and you select the required product. As soon as ur product is selected, remaining 2 columns are populated with the relevant data of the product and the cursor is moved to the quantity column. once some qty is entered you can add a new row now and move the cursor to the first column of the 2nd row... and so on...

The cursor won't move to the next row if a duplicate Item is selected/ if the qty is = zero.

Once all the items are entered, save them using the save button. For the purpose of which u may use the DataGrid. Making Editable MSFlexGrid/MSHFlexGrid requires much extra programming.

If u could give me a day's time, i can upload the modified form for u. I need some to modify the form suiting ur requirement.

If you can do it with getting some help on DataGrid, u can try by the time.

Akhtar sir ,
i am working in saudi arabia since it is a manufactering company
here financial year starts from january not from april ,in this month
means december 17 to december 31 i will have to complete at least
Material requistion form as well as purchase form . since it is having
seven department manufactering, engineering,purchase dept,sales dept ... all dept require Mr form in this month i will have to complete
at least MR Form and Purchase form as well as all concern report using Crystal report .

if you help me i will remain grateful to you.

can you give updated form for material requisiton upto tomorrow evening.

Here it is 6:00 PM. I can work it out and give it 2 u in another 3-4 hrs.
By the way what is the time there now?

sir
here time is 3:35 pm

ok. will get back to you by your time of 6:30pm

Thank you sir

Hi! I worked through the solution for nearly 5 hours. At last arrived at some sort of solution. i hope for the best that it will help u. I am uploading the ZIP File here.

NOTES ON USING THE SENT FILES.
-------------------------------------------
Unzip this file some where else other than your project. and Before overwriting any of your work with the given logic, make a backup of ur project.

I am sending a total of 8 files (3 Modules, 1 class module, 2 user controls of 3files and the MR form u have given)

once u have unzipped them to a location and having ur current project backup.

1. Open your CURRENT project with which u r working. (don't open "FINALMR.VBP" project which is included in the zip file i have sent you.)

2. From the Project->Components menu make sure u have these 2 controls are selected. a) Microsoft Hierarchical Flex grid Control (MSHFLXGD.OCX) and b) Microsoft Windows Common Controls-2 6.0 (MSCOMCT2.OCX)

3. Project -> Add Module and add the three modules i have sent one by one. (ADOSUPPORT.BAS, MODERROR.BAS & MODGLOBALVARS.BAS)

4. Project -> Add Class Module and add the PRODUCTS.CLS

5. Project -> Add User Control and add the "uscEntityCode.ctl" first. (IMPORTANT)

6. Then Project -> Add User Control and add the "uscMSFlexGridEditor.ctl"

7. Lastly Replace your MR form with the one which i have modified.

8. Run Check ur program and get back if any errors coming up or if u r unable to add these files to your project.

sorry i could not upload the files yesterday. you might have waited hoping for my reply. sorry for the inconvenience. Actual problem was that my internet connection was down from yesterday night till today morning. that was why i was unable to upload the solution. I had the code written yesterday night only by 10PM. (may be 7pm at ur side)