Counting of records in a continuous form

[mvorous]

What a rude lady you are. Please don't respond to any of my requests for assistance. I'd rather do without.
mvorous

 

[wiklendt]

i'm just trying to get my head around the purpose of this numbering system. i have asked repeatedly why this is being done this way and you have not replied to that question. i am trying to convince you that this is not a good way to go about it because i STILL don't understand the use of it. it makes no sense to constantly renumber people. it's going to cause mass confusion and muddle up all your linked data.

if people were to understand why you want it done this way and what purpose it is to serve and how it will work for you, then it will be easier to assist you finding an elegant and working solution. as it is, there is nothing that can be done to make this work because you have not provided satisfactory explainations on your project.

 

[boblarson]

I don't want the auto #. I have users assign large profiles to specific people, rather than use the peoples names, I have it set up for the assigner to simple pick a number. Person 1 would equal record 1, etc. It is very fast this way. I do it in VB but here in Access, it is becoming a nightmare. I can't seem to get the RecordCount to work for me. If a user goes in and changes the "lineup", it throws off the count - It should always be sequential with no missing numbers 1 2 3 4 5 6 7, etc.

Do not even go there. Just provide a combo box or list box to select the person they want. You're stepping into a mess from which you will see no good come of it and will only be feeling pain.

 

[wiklendt]

(told you...) ;-P

 

[dallr]

Mvorous
Although, Wiklendt might come off a bit strong I am in agreement with what she is pushing for.
I to cannot see the need for what you are asking, hence my comments.

Please explain in detail what it is you are trying to do. .

But seeing you are adamant of what you want, what else can we do

Dallr