Thanks in advance for help.

I have done a lot of large forms. - My boss does not want the secretary to have to open form and use the Find feature to bring up proper record.
HOW CAN I use/'link' a select query based on the client's ssn to bring up the proper form at the correct record?
ALSO, some clients have multiple records where the primary key is not SSN, but an IDnumber composed of ssn & 01 (or 02... etc. suffixes). Can I do the same thing here and have them scroll somehow, like with 'Find' on the form?

Please don't post the same question under multiple topics. It clutters the board and wastes peoples time when they see an unanswered version before they see an answered version. They take their time, which is valuable, to do you a favor and answer the question and later see that someone else has already provided a suitable answer. Choose the most appropriate topic or put it under General.