Lookup form.

  • Thread starter Thread starter Snide
  • Start date Start date
S

Snide

I want to create a form that will look up records via a social securtiy
number (ssn) from a table the data already exists. I do not want to add,
delete or edit any of these recrods from this form, it's for viewing
purposes only. I want to be able to type the person's ssn in the text box
and the record shows up. I don't want to use a list box or combo box,
unless they can be modified for my use. Can anyone help me with this?
Thanks.

Snide
 
I almost forgot...I also want the form to open as a blank then enter the ssn
to pull the record.
 
The easiest way to do this is to make the form unbound (ie nothing in the
RecordSource property). Add a subform to show the records you are pulling
based on the SSN. Then use your unbound textbox in the LinkMasterFields
property of the subform control and the SSN field in the LinkChildFields of
the subform control.
 
Well, List and Combo boxes are very modifiable, depending on what you
want to modify. List boxes, by default, don't allow you add values not
on the list. Combo boxes do, but you can change the default by setting
the Limit to List property to Yes. There's also a wizard for creating a
combo box to find records based on a field value you can use to create
the whole thing, which you can then modify as above. Finally, you can
set AllowEdits, AllowDeletions and AllowAdditions properties for the
whole form to No. That would make it a view-only form.

grep
 
Back
Top