Access forms that can find records....

[outhere]

Hi,
Can someone point me in the right way of creating forms within access 97 that would be able, by typing say...the phone number of a particular record, and retreiving the other data for that record in a specified table. Is it a form I'm even looking for?
* Just in case Im being too vague, I'm looking for a way to update client info in a "foolproof" kinda way for my client database.

cheers steve

 

[Lightning]

Set up a command button on your form, and add the following code to the On Click event of that button (making sure that you change the field and control names to your actual field/control names):

Private Sub cmdFindName_Click()
'Search for a Specific Surname in the "Surname" field.
On Error GoTo Err_cmdFindName_Click
Dim strLen, i As Integer
Dim strTempName, strSearchName As String

strLen = Len(strSearchName)

DoCmd.GoToControl "YourControlToSearch"
strSearchName = InputBox("Enter the Surname to search for.", "Look Up Surname&quot
DoCmd.FindRecord strSearchName, acAnywhere, , acSearchAll, , acCurrent, True
DoCmd.RunCommand acCmdFind


Exit_cmdFindName_Click:
Exit Sub

Err_cmdFindName_Click:
Msgbox Err.Description
Resume Exit_cmdFindName_Click

End Sub

What this code does is open the "Find" command (Edit|Find on the Menubar) and allows you to search for whatever you input.

HTH
Lightning

 

[redheadgeek]

Yes it is a form you want but, you will need to do some coding behind the scenes to pull in the record.

There are some further questions to answer...

First off when you create your form is it a bound (based on a table, usually created with the wizard) form or
an unbound (not based on a table, done manually).

Is the field you looking up your key index field? (Lookups on key fields go faster)

I have created a lookup for a database I wrote based on vehicle ids.

I can give you the code but how you set up the form is very important. The field that you do the lookup on must be an unbound field. if you want the code let me know.

 

[tlbroadbent]

Check the sample and download at this link.

http://www.mvps.org/access/forms/frm0045.htm

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.