Populate Form and Table with Related Fields

[Kevin Sullivan]

I have a table named tblData. It has fields [Client] and [State] in
it.
I have a table named tblStates. It has fields [S_Client] and
[S_State].
I have a data entry form named frmDataEntry. The form's source is
tblData now.

When a user pulls up the form, enters a [Client] and tabs out I want
[State] to populate on the form with the value from
tblStates.[S_State].
I also would like the tblData to store the [S_State] value in the
[State] field.

Any help would be appreciated. :^) !!

Thanks,

Kevin