Change Field In Table From Form

[Aldo]

I have two tables x and y. I have a form built from x.
In the x form I have a combo box controled by a field in
x but getting selection data from y. I would like for
the combo box to control the data in a second x field
with data from a second y field.

REMOTE LOCATION
Location Combo Location
Mileage Mileage

When I select a location from Location.Location in the
combo-box, how do I get the Location.Mileage into
Remote.Mileage

 

[Marshall Barton]

I have two tables x and y. I have a form built from x.
In the x form I have a combo box controled by a field in
x but getting selection data from y. I would like for
the combo box to control the data in a second x field
with data from a second y field.

REMOTE LOCATION
Location Combo Location
Mileage Mileage

When I select a location from Location.Location in the
combo-box, how do I get the Location.Mileage into
Remote.Mileage

Set the combo's rwo source to include bot columns from the
Locations table (change ColumnCount if needed). Then the
mileage text box can display the value for the location by
using the expression =[Location Combo],Column(1)