Opening sub form

  • Thread starter Thread starter gr
  • Start date Start date
G

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
 
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.
 
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
Click to expand...


.
Click to expand...
 
Back
Top