Finding records

[JimSmitty]

On my switchboard i'm creating a button that will find a record so that i am able to edit or delete it. These records are forms....How do i do that? The key that i want to use is the social security number of each participant. Can you help me please? <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>

 

[samara]

yeah, we can help you... but first tell us how you will get the value from the user (are you using form or just input box)<br><br>pls give us a whole overview, and you are welcome... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[jp1]

I use a combo box at the bottom of my form that will list 3 columns, ssn;fname;lname and have the control bound to column 1 (ssn).&nbsp;&nbsp;This then retrieves the record that I want to update.&nbsp;&nbsp;I have found that the most effective method of dealing with ssn information (possibly employees in your case) is to use a DateReleased field in each record and doing all of my work with the employee data files based on a query that tests for &quot;is not null&quot; in that field.&nbsp;&nbsp;Generally, you need to retain most ssn and employee data for an extended period, so it is inadvisable to delete these records.&nbsp;&nbsp;Just a thought.<br><br>Jody<br>Learning more about access everyday