Record Property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Which property will return the record number? I have a form with a button on
it that I want to return a particular record number (different from the ID
number), on another form. I am using the DoCmd.GoToRecord acDataForm and the
offset is asking for the record number and I don't know what to put there.
When I try to match the fields on the forms I get a Type Mismatch error.

Thanks.
 
OEB said:
Which property will return the record number? I have a form with a
button on it that I want to return a particular record number
(different from the ID number), on another form. I am using the
DoCmd.GoToRecord acDataForm and the offset is asking for the record
number and I don't know what to put there. When I try to match the
fields on the forms I get a Type Mismatch error.

Thanks.
Click to expand...

Access doesn't have record numbers. If you mean the "Record x of y Records"
that you see on the bottom of the form that is completely arbitrary depending on
how a form is filtered and/or sorted and cannot be used to find a particular
record.
 
Yes, that is the one I am referring to. So if that is the case, then what
can I use to bring back a particular record on another form that is already
open? As I said, when I use the ProjectName field, it says Type Mismatch,
and then when I change it to ProjectID, it says it can't find that record.
Any suggestions?
 
Back
Top