using the docmd.gotorecord command

[CD Tom]

I've been working on a problem and want to try using the docmd.gotorecord to get to a certain record in a table. I've got that figured out but I don't know what to do once i'm on the record. I want to select a usernumber from that record. It should be fairly easy to but I can't figure it out. Any help would be appreciated.
Thanks

[NeoPa]

CD Tom:
I want to select a usernumber from that record. It should be fairly easy to but I can't figure it out.

Do you mean you want to make the Control that's bound to the usernumber Field be selected as where the cursor is? If so, all the data selected or just the insert position added in there after the data?

[CD Tom]

I'll try and explain better. Here's the code I'm using.

    j = 2
 strsql = "select * from scores order by RandNumber ""
    Set rsscores = db.OpenRecordset(strsql)
    Do While Not rsscores.EOF
            DoCmd.GoToRecord acDataTable, "rsscores", acGoTo, j
            SXFDA = rsscores("XFDANumber")
J = J + 2
rsscores.movenext
loop
 

there's other code but when I get to the docmd.goToRecord i get an error that rsscores isn't open

[cactusdata]

Use the recordset and FindNext:

strSQL = "select * from scores order by RandNumber"
Set rsscores = CurrentDb.OpenRecordset(strSQL)
If rsscores.RecordCount > 0 Then
   J = 2
   rsscores.MoveFirst
   Do While Not rsscores.NoMatch
      rsscores.FindNext "XFDANumber = " & SXFDA & ""
      J = J + 2
   Loop
End If
rsscores.Close

[NeoPa]

Hi Tom.

Certainly there are Methods that you can (should) use when working with recordsets, which are quite different from what DoCmd and all it's Methods will give you. DoCmd typically works as an imitator of the human operator (In this case, takes you to a record on whatever (Form/Report/Datasheet) object is currently selected within the Access session.) whereas Methods of other objects help utilise those particular items. Generally it's preferable to use the latter where possible.

However, your question seems to imply (Correct me if I have this wrong.) that, for unstated reasons, you would actually like to use DoCmd specifically. If it's for manipulating a code recordset, IE. One that is not available to the operator directly - then you're out of luck I'm afraid. It only works as a way to work with items that are human-interfaceable.

I hope that makes sense.

[NeoPa]

I have a rule of thumb that says use DoCmd when, and only when, there is no Method or Property that can work more directly with that which you're working with. It's a last-resort. It can be very helpful & important, especially where the interface doesn't provide a way to do it using the object model as defined. Otherwise though - I avoid it.

[CD Tom]

What i'm trying to do is get the XFDAnumber from the 2nd record in the file, I will then update that number into another file in record 1 then get the 4th record and put that into record 3 of the other file and so on.
Don't know if that makes sense or not.

[CD Tom]

NeoPa
I'm still working on the problem with the runners and not matching them up with the same person. I thought if I could put the runners number in a file and put the runners number they are match with that way I will have a place to look to see if that runner has ever been matched with that runner and if so select a different runner.
Does that sound like it might work???

[NeoPa]

CD Tom:
Don't know if that makes sense or not.

Very little. The natural lack of clear explanation is exacerbated by the use of many terms out of place. What strikes me as most important though (I can & do get past such shortcomings regularly.) is that there is no reference at all to the points I'd raised. You simply haven't dealt with them and that leaves me somewhere before first base.

[NeoPa]

CD Tom:
Does that sound like it might work???

I don't mean to sound snippy here but that may as well be in Mandarin (Not the orange). You ask a question about using DoCmd, and the next thing I know you're explaining something based on the internals of your particular database.

I do still want to help, but you need to communicate in such a way that someone reading has an idea of what you want.

As I mentioned before - when I post something in response it will always be hard for me to proceed unless you read and respond to that. Simply skipping over/past it is very confusing to someone in my position. Have you understood what I posted? Do I need to post the same again? If you really must jump around onto different subjects then a new thread would generally be required.