Opening sub form

[gr]

Hello!
I have Form1 which contains sfrmA
I want to open Form1 and make sfrmA to load just for
Adding new records. So either I don't want all the sub
form's records to be shown or that the cursor is placed on
the last record of sfrmA. Is this possible?

Thanks in advance,
gr

 

[Sandra Daigle]

In the open event of the form you can add a statement to go to a new record
on the subform:

Me.sfrmMySub.SetFocus
DoCmd.GoToRecord , , acNewRec

Where sfrmMySub is the name of your subform control.

 

[gr]

Thx I accomplished exactly what I wanted by setting the
DataEntry Form Property = True

Thank you

-----Original Message-----
In the open event of the form you can add a statement to go to a new record
on the subform:

Me.sfrmMySub.SetFocus
DoCmd.GoToRecord , , acNewRec

Where sfrmMySub is the name of your subform control.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hello!
I have Form1 which contains sfrmA
I want to open Form1 and make sfrmA to load just for
Adding new records. So either I don't want all the sub
form's records to be shown or that the cursor is placed on
the last record of sfrmA. Is this possible?

Thanks in advance,
gr

.