Finding record in a sub form using FindRecord

[psamps]

Hello,
I am trying to use the FindRecord function in my 2003 database.
My code is

Dim Orderho As Integer
Orderho = Me.cboFindByOrder
Forms!test!Order!OrderID.SetFocus
DoCmd.FindRecord Orderho, , True, , True

It does not work when I use the variable, but will work if I put a number figure such as 12 in teh function for example

DoCmd.FindRecord 12, , True, , True

Is the problem with declaration of the variable?
Any help would be appreciated thanks
Peter

[PhilOfWalton]

The declaration should be of the same type as the field being searched, so guessing that OrderID is an autonumber, Autonumbers are Long

Assuming that Forms!test!Order is a subform, to refer to a control on it (such as OrderID) use

Forms!test!Order.Form!OrderID
 

It's always worth putting a halt in your code, and checking whether Forms!test!.Form!Order is actually getting the focus

Phil

[NeoPa]

You say it does not work, yet you don't tell us what does happen. An error description is helpful for errors. If it simply doesn;t find the correct record, or move the record pointer at all, we also need to know that.

[psamps]

Thank you for your replies,
I have changed the variable to Long and added the line of code
Forms!test!Order.Setfocus before
Forms!test!Order.Form!OrderID.SetFocus
to make sure that OrderID has the focus
but it still does not work. There are no error messages either but now OrderID has the focus.
Thanks

[NeoPa]

I assume then that what you mean but not working must be that it doesn't move from the current record. I'm afraid I can't see why. I would assume that there is something which is causing it to fail but which you haven't shared with us.

Generally I would expect code such as that to work.

I can state unequivocally that the focus was fine in the first instance as when you used the literal value 12 it did work. So, it seems clear there is something about the variable used. You could try using Val() around the reference to your variable. That should work, but it isn't the answer to your question. We can only help with that when we know what it is you aren't telling us.