information already in database dont retype name address city stat

K

KAT

if the information is already in the database I dont want to retype the same
information again unless its changed because person moved. When the ss# is
enter in then the person name, address, city, state, and phone number will
appear in the form so I can continue with the rest of form. Some names will
be entered in several times a month. what can I do
 
M

Micah Chaney

I'm not entirely sure I understand your question. Do you want to be able to
type in a SSN and have a person's detail appear on the screen? If so you
need to base this form off of a Query. This will allow you to create a
Parameter Prompt which will allow you to enter a SSN and provide only those
results that match that SSN. Now when you say a person's name can appear
several times a month, this is what you don't want correct? Because if a
person's SSN is being used as a Primary Key type then you would only want
that to appear once, right? Let me know if I understand this correctly and
if you need help setting up Parameters.
 
K

KAT

The form I have is a transportion Log Form when the user types in the SSN the
owner of the SSN name, address, city, state, phn # will appear if it has
already been entered into the database, if not then the user will need to
fill in this information before they can continue (set as a required field)
then all the user needs to do is finish with the form so that way they dont
have to re-enter information that is already in the database. The SSN might
be used more than once a month depending on if they need transportation for
their appointment to the hospital. I dont have the SSN set as the primary key
I was going to but I haven't.
 
M

Micah Chaney

I see. I don't know how to do that in one step like you seemingly want.
Just to see if I understand you correctly...You want a user to basically
start entering a Form by inputting a SSN. If the SSN is currently in the
database, the Form auto populates certain fields and the user does the rest.
If the SSN isn't in the database (ie New Customer) then the user would be
forced to input the Customer's information first (thus saving it for future
reference) and then continue with the rest of the form. Is this correct?

I can have you do a two-step process, meaning the user enters the SSN and
the information pops up or you get an error, which would force the user to
back up a step and input the customer information. Would that work, or do
you want to wait and see if someone else has a better solution? Let me know.
I'm gonna work on I guess "Plan B" for you.
 
K

KAT

please work on plan b for me if you dont mind you have the right idea of what
I'm needing. thanks
 
Top