...= Nz(DMax("...

[an]

Hello!

I have a command button, for add new record with
incrementation new number, in MainForm, I use:
Me.IdPerc.Value = Nz(DMax("IdPerc", "T_Perc"), 0) + 1

Now, I would like to increment new record in SubForm,
where the IdPerc was of the MainForm. This SubForm is
based in T_Troc.
In adition, One Perc to many Troc.

Thanks in advance.
an

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com) is a small Access database
sample called: "FormSubform.mdb" which illustrates this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[an]

Thanks for your reply.

Already your site knew but this example not.
Thanks more one time.
an

 

[an]

Sorry.

Isn't possible to have a continous form, please?
Thanks.
an

 

[an]

Sorry
It would like to have asked: SingleForm (?)
an

 

[Roger Carlson]

It doesn't matter whether the subform is single form, continuous form, or
datasheet. It should still work the same. If you modify my sample to make
the subform a single form view, it still works.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[an]

Exactly!

Now, my difficult is to aplly your sample to Command
button, where one click to add new record through SubForm.

Many thanks.
an