[mso] Re: ACCESS - Update Records
- From: "Peter Chiavaro" <kp@xxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 24 May 2002 08:34:22 -0400
Good Morning Charlie,
Yes, ...now I think I know what you mean.
You want to choose something in a combo box on a form and after choosing =
it, you want other fields in the same form to be "filled in" according =
to what you have chosen in the Combo Box... right?
If this is the case, then it's really simple to do.
First tell me this is what you want, and then I'll tell you how to do =
it.
Peter C.
Stuart, Florida
? Kp@xxxxxxxx
-_-_-_-_-_-_-_-_-
ICQ =3D 412633
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On =
Behalf Of Charles Ippolito
Sent: Thursday, May 23, 2002 1:47 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: ACCESS - Update Records
I guess outside of Dian's method, and your method, Pete, maybe we can =
look at this in another way...
Maybe this way would be easier...
While entering a record, can I have a field do some sort of lookup into =
another table, say, based on data in one field, it would return related =
data in ANOTHER field? Like, if I entered "10034" in the ZIPCODE field, =
the CITY and STATE field would automatically return "NEW YORK, NY". So, =
in effect, it would just enter the data, not really relate it to another =
record in another table. And, overall, the lookup is done while entering =
the data, so changing data later on wouldn't affect the order entered... =
know what I mean?
=20
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions.
*************************************************************
Other related posts:
