Hi there. This problem probably requires a macro or code, but since it occurred on a form, I put it here.
There are problems with the "search" button on a form which contains various names of clientele. This form has several subforms that are linked, but I don't think this has any bearing on the problem.
I'd like the "search" button to put up a inputbox asking for the last name of the client, and then go to that record within that same form. But the Goto command in Code can only use integers indicating record number. The only problem is, new clients are entered every day, and the Form is linked to a Query which re-alphabetizes them (I don't know how to use a Refresh or Requery command syntactically). So the record number is never constant for a given Last Name.
I hope I'm making sense, but does anyone know of a way to jump to a record without manually searching for the name (in the query)and counting its record number? Thanks for reading.
There are problems with the "search" button on a form which contains various names of clientele. This form has several subforms that are linked, but I don't think this has any bearing on the problem.
I'd like the "search" button to put up a inputbox asking for the last name of the client, and then go to that record within that same form. But the Goto command in Code can only use integers indicating record number. The only problem is, new clients are entered every day, and the Form is linked to a Query which re-alphabetizes them (I don't know how to use a Refresh or Requery command syntactically). So the record number is never constant for a given Last Name.
I hope I'm making sense, but does anyone know of a way to jump to a record without manually searching for the name (in the query)and counting its record number? Thanks for reading.