chrisjames25
Registered User.
- Local time
- Today, 20:36
- Joined
- Dec 1, 2014
- Messages
- 404
Hi. I'm not sure if this is possible as I cant find away but I thouhgt before i give up i will ask on here.
I have a form with 2 subforms on it.
The first subform lists all my sales orders and the data is presented as a continuous form. On the subform is a command button to click to edit the data and there is also a second command button. When this button is clicked it show the details of thesales order in the second subform.
My problem is that I would like to highlight the line i have just clicked in the 1st subform so I can see which sales order the data now populated in the second form realtes to. Whenever i do a backcolor change on click of comman button it changes the backcolor for every input in subform 1. I beleive this is a limititation of continuous forms but just wondered if anyone smarter than me had figured out a workarond.
My only workaround at the moment can be seen in the image attached whereby on clicking the showdata button it populates the data in the main form just above the second subform. Whilst ok I would rather see the data line i just clicked highlighed in the 1st subform.
Apologies if this is a bit rambly but hopefully it makes sense.
thanks in advance.
I have a form with 2 subforms on it.
The first subform lists all my sales orders and the data is presented as a continuous form. On the subform is a command button to click to edit the data and there is also a second command button. When this button is clicked it show the details of thesales order in the second subform.
My problem is that I would like to highlight the line i have just clicked in the 1st subform so I can see which sales order the data now populated in the second form realtes to. Whenever i do a backcolor change on click of comman button it changes the backcolor for every input in subform 1. I beleive this is a limititation of continuous forms but just wondered if anyone smarter than me had figured out a workarond.
My only workaround at the moment can be seen in the image attached whereby on clicking the showdata button it populates the data in the main form just above the second subform. Whilst ok I would rather see the data line i just clicked highlighed in the 1st subform.
Apologies if this is a bit rambly but hopefully it makes sense.
thanks in advance.