Change Field In Table From Form

  • Thread starter Thread starter Aldo
  • Start date Start date
A

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
 
Aldo said:
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
Click to expand...


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)
 
Back
Top