C
Chris Ryner
Can anyone offer me some pointers.
I have a form bound to a tblTENANTMST with two subforms
on it which are bound to there own respective tables.
subform RENT is bound to tblRENT and subform ADDER is
bound to tblADDER.
From frmTENANTMST the subform data is NOT EDITABLE.
however with the current record on the form the click of
a command button will open frmRENTEDIT a form bound to
the table and displaying only the records pertaining to
the current record of the parent form and allow editing
of the data.
when finished with the editing you click a button on
frmRENTEDIT that closes the form.
Heres the problem. You must move off the current record
and then back to see the changes. If I put a
Forms!frmTENANTMST.requery in the click event of the save
and close button the recordsource for the parent form is
requery which refreshes the dataset however it also moves
to the first record. I want to click the save button and
have the frmRENTEDIT close and the frmTENANTMST stay on
the current record but have its subform requery.
I have tried (in the SAVE_click event on frmRENTEDIT)
Forms!frmTENANTMST.Requery - goes to first record
Forms!frmTENANTMST.RENT.Requery - RENT is name of the
subform control on the parent form - no apparent effect
What else can I do?
Any thoughts, ideas, examples would be greatly
appreciated.
I have a form bound to a tblTENANTMST with two subforms
on it which are bound to there own respective tables.
subform RENT is bound to tblRENT and subform ADDER is
bound to tblADDER.
From frmTENANTMST the subform data is NOT EDITABLE.
however with the current record on the form the click of
a command button will open frmRENTEDIT a form bound to
the table and displaying only the records pertaining to
the current record of the parent form and allow editing
of the data.
when finished with the editing you click a button on
frmRENTEDIT that closes the form.
Heres the problem. You must move off the current record
and then back to see the changes. If I put a
Forms!frmTENANTMST.requery in the click event of the save
and close button the recordsource for the parent form is
requery which refreshes the dataset however it also moves
to the first record. I want to click the save button and
have the frmRENTEDIT close and the frmTENANTMST stay on
the current record but have its subform requery.
I have tried (in the SAVE_click event on frmRENTEDIT)
Forms!frmTENANTMST.Requery - goes to first record
Forms!frmTENANTMST.RENT.Requery - RENT is name of the
subform control on the parent form - no apparent effect
What else can I do?
Any thoughts, ideas, examples would be greatly
appreciated.