newbie

[trhq]

I am very new to Access. I am working on a small program -
i know it sound so simple to most of you.

Anyway, I can't figure out how to do the following things.

My table/form (Main) has the following fields;
Name
Address
City
State
Zip
Networth

I have a separate table (ZIP) that has fldZip, fldState and fldCity
< used in form as: SELECT [Zip].[fldZip] FROM Zip; >

How do I auto replace the City and State when I entered Zip
on the Form. I was able to get the Zip but do not know how
to replace the City and State automatically when I pick on ZIP.

And, how to I replace the value of Networth to zero if given value is
negative.

I can share my Complete USA Zip Table if you can help me. Thanks

TP

 

[Ken Snell]

See this page at The Access Web for one way to do this:
http://www.mvps.org/access/forms/frm0058.htm

It will require that you expand the query that is the Row Source for the Zip
control.

Suggestion: Do not use Name as the name of a field or control. Name is a
reserved word in ACCESS, and you can greatly confuse ACCESS if you also name
a field or control as Name.