I've made an input form with a Data Entry setting of Yes and a Default View of continuous forms. I want the sequential number of each record to show in the form. That is, record 1 has a 1 in it, record 2 has a 2 in it.

Thank you for your help.

Mark J. Weisberger

__________________
Mark J. Weisberger

Use Total Count in the Begining and When you display a record get RowID and show as RowID/TotCount (1/10 or 1 of 10).

I hope you are taking abt the Master Record --> Transaction Records. Same way you using the count can do.

I'm not sure what you mean, but I got the solution using CurrentRecord. I added a field to the underlying table called RecordCounter. Then I put this field in the input form as a bound text box. In the After Update event procedure of the first field of the form I put Me.RecordCounter = Me.CurrentRecord. This gives sequential numbering of the input records in the input form.

Mark J. Weisberger

Hello,

For automatic sequencing of the data. There are two methods you can go with. Please have a look:

1. In the database, you can make the first column auto increment, so with every entry it will automatically take the sequencing and will also make the data look good.

2. If you need it in the application, then you have to make a function to check the number of rows that you have entered and according to it you have to display the number.

I am a programmer, so if you need code then let me know. You may also check this article for some good stuff.

Regards
----------

Database Security and why you need to review yours ... not something you can shun and pretend it's a monster under the bed

Try with these steps

Open the form in Design view.
Double-click the form selector to open the form's property sheet.
Do one of the following:

If you don't want the form to display existing records, set the DataEntry property to Yes.

If you want the form to open with all records showing, set the DataEntry property to No.