How to Set Focus to a Record and Using FindFirst

[BallinWallin]

If you are here to answer questions, thank you for taking the time to read mine.



The basic operation is my form searches through a table for any record whose targeted field matches a value input by the user. If one exists, several text boxes on the form are populated with other fields from that record. That all works fine.

The problem occurs when I change or add to the text boxes and call my update sub. For some reason, the update overwrites the first record in my table instead of the one that (I thought) had focus. The code that searches through the table to find the record of interest exits as soon as it has found the right one, and the update procedure that is subsequently called doesn't have any table navigation commands so I don't understand why the focus is not still on the record of interest where I left it.

I tried to remedy the situation with the FindFirst command thinking that maybe exiting the sub caused some sort of focus reset. So I created a public integer variable and it is set equal to the AutoNumber ID field when the correct record is found but that didn't work. When the update sub is run and the FindFirst line executes I get run-time error 3070 saying "...database engine does not recognize LoadedRecord (the variable name) as a valid field name or expression." I'm sure I'm not using the FindFirst method correctly and I'm unable to find an explanation of its syntax online, so could someone please explain it in painful detail for me? And is there perhaps a better way for me to do this rather than using FindFirst at all.

.FindFirst "[ID] = LoadedRecord"

I would be happy to post more or all of my code but I didn't want to make this too lengthy. Thank you very much for your time and help.

[ItsMe]

Can you post the code in your sub procedure that is giving you unexpected results?

As for
.FindFirst "[ID] = LoadedRecord"

Maybe
.FindFirst "[ID] = " & LoadedRecord

[BallinWallin]

Hahaha, always so simple. Thank you very much. It works now but I would be happy to post my code anyway if you think it would help someone else.

[ItsMe]

Yes, post your code. I still do not fully understand your question and how it relates to the symptom. All I understand at this point is you were able to employ the .FindFirst method successfully. There may be a more direct or eloquent approach.