Show newly added record

[Kaur]

Hi,

I am working in MS Access 2000 and have created two forms. Form 1 is
called frmParent (which has a subform called SfrmChild). FrmParent has
a list box that lists all the Last Names of parents in the db. Clicking
on one of the lastname of parent in the list box shows children of
selected parent in the SfrmChild. I have a button on frmParent that
opens up a pop up form where user can add children to the selected
parent. My problem is when I close the pop up form, It does not take me
to the selected parent for whom I added the children. For example if I
added children for Mr.Smith, the children gets added to subform but
closing the pop up form does not take me to Mr. Smith's record. How can
I automate that each time I add children for a selected parent, closing
the pop form will take me to the selected parent's record for whom I
added the children.

I will appreciate any help.

Thanks

[ComputerJunkie]

Kaur wrote:

Hi,

I am working in MS Access 2000 and have created two forms. Form 1 is
called frmParent (which has a subform called SfrmChild). FrmParent has
a list box that lists all the Last Names of parents in the db. Clicking
on one of the lastname of parent in the list box shows children of
selected parent in the SfrmChild. I have a button on frmParent that
opens up a pop up form where user can add children to the selected
parent. My problem is when I close the pop up form, It does not take me
to the selected parent for whom I added the children. For example if I
added children for Mr.Smith, the children gets added to subform but
closing the pop up form does not take me to Mr. Smith's record. How can
I automate that each time I add children for a selected parent, closing
the pop form will take me to the selected parent's record for whom I
added the children.

I will appreciate any help.

Thanks

Kaur, when you move back to the frmParent, hit the F9 key - this
carries out a page refresh.
If you want to do this automatically, you can set up an auto refresh
(known as a requery) in the AfterUpdate method of the frmParent and the
OnClose method of the SfrmChild. The command would look something like
this:

sub SfrmChild Close()
docmd.openform "frmParent"
docmd.close acDefault
end sub

sub frmParent AfterUpdate()
docmd.requery
end Sub

Hope this helps.
D

[Kaur]

Thanks for the reply,
My problem is the subform does get updated but it does not show me the
record for which I added the children. e.g. If I added the children for
Mr. Smith, on closing the pop up form it shows me the record that comes
first in ascending order of the parent listbox.
I want the popup form close action to take me back to Mr. Smith's
record.

Manjeet

ComputerJunkie wrote:

Kaur wrote:

Hi,

I am working in MS Access 2000 and have created two forms. Form 1 is
called frmParent (which has a subform called SfrmChild). FrmParent has
a list box that lists all the Last Names of parents in the db. Clicking
on one of the lastname of parent in the list box shows children of
selected parent in the SfrmChild. I have a button on frmParent that
opens up a pop up form where user can add children to the selected
parent. My problem is when I close the pop up form, It does not take me
to the selected parent for whom I added the children. For example if I
added children for Mr.Smith, the children gets added to subform but
closing the pop up form does not take me to Mr. Smith's record. How can
I automate that each time I add children for a selected parent, closing
the pop form will take me to the selected parent's record for whom I
added the children.

I will appreciate any help.

Thanks

Kaur, when you move back to the frmParent, hit the F9 key - this
carries out a page refresh.
If you want to do this automatically, you can set up an auto refresh
(known as a requery) in the AfterUpdate method of the frmParent and the
OnClose method of the SfrmChild. The command would look something like
this:

sub SfrmChild Close()
docmd.openform "frmParent"
docmd.close acDefault
end sub

sub frmParent AfterUpdate()
docmd.requery
end Sub

Hope this helps.
D