A
Allison
Below I have an event procedure that fills in other fields
automatically.
Private Sup Zip Code_AfterUpDate
If ZipCode is entered fill in city and state automatically.
Select Case Zip Code
Case "10000" to "10200"
City ="New York"
State = "NY"
Case "98100" To "98199"
City ="Seattle"
State = "WA"
End Select
End Sub
I want to use this same procedure in a query
(I'm not sure which one??) with two tables.
I Want to autofill 4 fields based on one field.
I already have an Access table set up but one
table is an ODBC table(pulled in Access) and the other
with all the transaction is a regular table in Access.
One table has an 8 digit field entitled (CAN)
with 6900 transactions. The other TABLE looks like this:
CAN Research Division Pool Notes
0789 BIOD DAIDS RPG PROJECTS & CENTERS
I would like this table above to go over and find the last
four digits on the other table and perform the above
autofill function. Is this possible and can you show me
how to accomplish this. Keep in mind I have 150 different
types of CAN changes.
automatically.
Private Sup Zip Code_AfterUpDate
If ZipCode is entered fill in city and state automatically.
Select Case Zip Code
Case "10000" to "10200"
City ="New York"
State = "NY"
Case "98100" To "98199"
City ="Seattle"
State = "WA"
End Select
End Sub
I want to use this same procedure in a query
(I'm not sure which one??) with two tables.
I Want to autofill 4 fields based on one field.
I already have an Access table set up but one
table is an ODBC table(pulled in Access) and the other
with all the transaction is a regular table in Access.
One table has an 8 digit field entitled (CAN)
with 6900 transactions. The other TABLE looks like this:
CAN Research Division Pool Notes
0789 BIOD DAIDS RPG PROJECTS & CENTERS
I would like this table above to go over and find the last
four digits on the other table and perform the above
autofill function. Is this possible and can you show me
how to accomplish this. Keep in mind I have 150 different
types of CAN changes.