how to "findRecord" from unbound control

[aidan]

How do I find a record number from arbitrary criteria so that I can use gotoRecord? I just can't find which function.

Thanks in advance,

Aidan

 

[aidan]

I found this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=14562&highlight=absoluteposition

but I get runtime error 2105, you can't go to the specified record. I checked with a messagebox and the value isn't null or out of bounds.

Aidan

 

[aidan]

Sorry, but I'm not using a query like that. The form is bound, but the control I'm searching for the primary key isn't. Might there be another reason for this error?

Aidan

 

[KeithIT]

Aiden,
Is the control you are searching unbound or is the control the box you are using for the search. If it is unbound, then how are you searching it for a primary key?

If not, then try setting a bookmark rather than using GoTo

 

[aidan]

Hi,

Sorry, I was just trying to find how to pull the thread - it started working after I closed and reopened the form. Is this possible on this forum?

The problem was that I was changing from an unbound parent form to a bound one. From setting the the linking control's value, to letting this happen automatically by navigating to the appropriate record. Access was just playing up until I had a crash and recover...

Aidan