Hey people!
Me again
This is going to be a little more difficult to explain but here goes.
3 forms
MAIN FORM: frm_trust
SUB FORM: subform_notes-trust (continuous form)
POPUP FORM: ext frm_createtrustnote
Now on the 'frm_trust' is a subform called 'subform_notes-trust', this has a button which on click pops-up 'ext frm_createtrustnote' of which you enter the data and click 'OK' and it adds it to the database and then '[subform_notes-trust].Requery' to get the form to update the continuous form with scolling showing the item you have just entered.
For each new item listed in the 'subform_notes-trust' it places a button next to it of which you can click on and it opens up 'ext frm_createtrustnotes' containing the data of which you edit and then click on update to..well update the data.
The trouble comes when you have 3 items listed in the 'subform_notes-trust', you click on the edit button on the last record, make your changes then click on update it takes you back to the 'subform_notes-trust' screen but scrolls right to the bottom of the list.
It looks like it has cut off all data above the last record, when all you have to do it click on the 'Up' of the vertical scroll to bring it all back into sight.
Is there anyway to 'Requery'/'Refresh' the 'subform_notes-trust' without it doing this?
Cheers!
- F8i
Programmer
e: f8i@f8i.co.uk
Me again
This is going to be a little more difficult to explain but here goes.
3 forms
MAIN FORM: frm_trust
SUB FORM: subform_notes-trust (continuous form)
POPUP FORM: ext frm_createtrustnote
Now on the 'frm_trust' is a subform called 'subform_notes-trust', this has a button which on click pops-up 'ext frm_createtrustnote' of which you enter the data and click 'OK' and it adds it to the database and then '[subform_notes-trust].Requery' to get the form to update the continuous form with scolling showing the item you have just entered.
For each new item listed in the 'subform_notes-trust' it places a button next to it of which you can click on and it opens up 'ext frm_createtrustnotes' containing the data of which you edit and then click on update to..well update the data.
The trouble comes when you have 3 items listed in the 'subform_notes-trust', you click on the edit button on the last record, make your changes then click on update it takes you back to the 'subform_notes-trust' screen but scrolls right to the bottom of the list.
It looks like it has cut off all data above the last record, when all you have to do it click on the 'Up' of the vertical scroll to bring it all back into sight.
Is there anyway to 'Requery'/'Refresh' the 'subform_notes-trust' without it doing this?
Cheers!
- F8i
Programmer
e: f8i@f8i.co.uk
