Hello every one
I know its a silly question but if i want to have the current record number without using record navigation option what should i do

Best Regards,

Best Regards,
Hamed Gholamian

Hamed, what do you mean by "want to have the current record number"? Do you mean that you want to know what the current record number is? Please clarify. Thanks.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

First of all very thanks
ok i have a form like this (example)
1- john adams
2- Alan adams
3- Joe Adams

Current Record: 1

Name: John Adams
----------------------
Current Record: 3

Name: Joe Adams


As you see in above my current record: is my problem



Best Regards,
Hamed Gholamian

I hope I understand this. Please flesh out your problem more clearly if I get this wrong.
The assumption is:

You want to open a form with the right data showing on the form for a specific person. You don't want to open a form and use the record navigation buttons on the bottom of the screen.

When you open the form you can choose parameters of the forms query back end. I'm assuming your form has its own record set if you use the navigation buttons.

Alot of assumptions

Change the action where you open the form using 1 of 2 techniques. Using the where or filter arguments of the openform command, or using the openargs argument. Look these up help if you need more information on how to use them (in Access Help). Here are some examples.
In the case where you have a query back end or recrodset for your form.
This will limit the value of the form you open to coincide with your customerID, substitute the appropriate name of your field. (using the where clause).


DoCmd.OpenForm "THE FORM YOU WANT TO OPEN", acNormal, ,"customerID = " & (the customer id) , ,


If you don't have a query based form you can use the openargs parameter (the next example)to pass whatever information you want to the for you are opening and then in your form_open method you can use something to look up all the data you might need.

DLookup() is a good example.


DoCmd.OpenForm "THE FORM YOU WANT TO OPEN", acNormal, , , , , (the customer id)

Roni Estein
[email protected]
https://www.e-drugsCanada.com

I would suggest you display it as a caption of a label, in the example, with the name 'lblRecordnum, but you could make it a textbox with the locked property set true.

In the form current event:

Private Sub Form_Current()
    Me.LabelRecNo.Caption = Me.Recordset.AbsolutePosition
End Sub

If you make it a textbox that the user can type in, you can attempt to move the recordsetclone to the absolute position and if there is no error, set the form bookmark equal to the recordsetclone bookmark to move the form to the record and undo the texbox on error, all in the textbox afterupdate event. This is also functionality of the display textbox included with the default record navigation buttons.



Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

First of all very thanks
ok i have a table like this (example)
record no | Name
----------|------------
1 | john adams
2 | Alan adams
3 | Joe Adams

I want to have text box to show me the current record number

Current Record: [u]1</u>

Name: John Adams
----------------------
Current Record: [u]3</u>

Name: Joe Adams


As you see in above my current record: is mt textbox

Best Regards,
Hamed Gholamian


Best Regards,
Hamed Gholamian

If you have "record no" being the same as your "current record number", then you can just have the text box on the form.

However, if you want it to be something else, then you've got a bit of a problem.

Record numbers are completely arbitrary.
Say for example you have these values:
Apple
Banana
Carrot

In that order, you'd have Apple being record 1, Banana being Record 2, Carrot being record 3.

Sort that DESCENDING however, and you'd have Carrot being record 1 and Apple being record 3.

To make it more relevant to you - if you didn't have "record no" in your table, the "current record number" for "Joe Adams" could be anything, and mean nothing. It could be 1, it could be 2, or it could be 3.

So I say - just put a textbox for your "record no" field if you really have to have it.

I am a loud man with a very large hat. This means I am in charge

Dear steven i completely undrestand your point but its hard to explain.
u know when you create a new form you have record navigation with record selector i.e. first next previous last and in the middle current record number which will tell you the current record number and its not relative to your table its just a number thats what i want


Best Regards,
Hamed Gholamian

Hamad,

I have exactly the same requirement in an application I developed. I need a "record number". I found the best way was to have a "record number" field in the table (this can be in addition to, or instead of, the autonumber field). Create the record number - ie whatever you want it to be - at the time you create the record. Then everything will work out alright.

HTH
Clive

Clive Astley

Well, if it's a meaningless number you want, you could either have a REALLY meaningless number, by using the Rnd function, but that's probably not what you want.
Jurgen probably put you in the right direction more than any of the other posts.
Just change his label syntax to match a textbox, so you'll have something like:

I am a loud man with a very large hat. This means I am in charge