auto encode

[trhq]

I want to automatically fill in the field values of my Form that uses
a table (DIRECTORY) that has the following fields (sample);
NAME
PHONE
ADDRESS
ZIP
The form has a combo box for ZIP that relates to a Query
using ZIPCODE table that has fields: ZIP, CITY and STATE

At first I was using it as a linked table that automatically
display the values of City and State using [ZIP].[Column](1).

However, I like to add STATE and CITY fields in the DIRECTORY table.
I can't figure out a way to automatically get corresponding values (to use
as default value for city and state) whenever I pick on zip from the combo
box.

help please. thanks.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm assuming that the query for the Zip ComboBox is like this:

SELECT ZIP, CITY, STATE FROM ZipCode

When the record is saved use the Form's BeforeUpdate event to load the
City and State fields in the form's RecordSource. E.g.:

Private Sub Form_BeforeUpdate(Cancel As Integer)

If Not IsNull(Me!Zip) Then
Me.City = Me!Zip.Column(1)
Me.State = Me!Zip.Column(2)
End If

End Sub

HTH,

MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7wXs4echKqOuFEgEQKqzACg3CabIsStf6vLPQHH8QgxUG o0uu0An3Mn
dCDvkKpkmQgJ+d/SmdQHM0aE
=kc9a
-----END PGP SIGNATURE-----

trhq wrote:

I want to automatically fill in the field values of my Form that uses
a table (DIRECTORY) that has the following fields (sample);
NAME
PHONE
ADDRESS
ZIP
The form has a combo box for ZIP that relates to a Query
using ZIPCODE table that has fields: ZIP, CITY and STATE

At first I was using it as a linked table that automatically
display the values of City and State using [ZIP].[Column](1).

However, I like to add STATE and CITY fields in the DIRECTORY table.
I can't figure out a way to automatically get corresponding values (to use
as default value for city and state) whenever I pick on zip from the combo
box.

help please. thanks.