Consecutive Number in a subform

[Guest]

Hi all
I have a subform named:2_Control_subform and I have a field numed:Item_No
where I want to put the item number, example:
first row =1
second row =2
third row =3 and so on
I don't know where put this event and how it must be, could you please help
me on this,

Thanks
LD



--
Lorenzo Díaz
Cad Technician

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-b149-06b032d12ab3&dg=microsoft.public.access

 

[Larry Daugherty]

Where you put the code is in the Default Value for that textbox on
that (sub)form.

There are two issues to address: The way to get the value you want to
insert as the default will be based on DMax() + 1 for the field in the
table on which the subform is based. Probably more difficult to get
going correctly will be how to address controls on subforms. There is
a great write-up on it on www.mvps.org/access

HTH
--
-Larry-
--

Hi all
I have a subform named:2_Control_subform and I have a field numed:Item_No
where I want to put the item number, example:
first row =1
second row =2
third row =3 and so on
I don't know where put this event and how it must be, could you please help
me on this,

Thanks
LD



--
Lorenzo Díaz
Cad Technician

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-b149-06b032d12ab3&dg=microsoft.public.access