How to construct form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G S - 29 Jan 2006 00:44 GMT

Heres what i got. any help would be wonderful...
I have two table- Destinations and DrivingRecords
Destination has two columns. on the left a list of places and on the right
the milage.

Driving Records has four columns. Job # (autonumber) , Date , destination,
and milage.

I am trying to make aform where they will type in the date and select from a
combo box there destination.
I can do this. These records make up the DrivingRecords Table. But how can
i get the milage to transfer also. i dont want the milage to be editbale
either. All i want the workers to do is be able to type i the date and
select the place from the combo box.

Reply to this Message

G S - 29 Jan 2006 07:09 GMT

the combo box shows both columns from the destination table (location and
milage)
i tried making a seperate text box below the combo box . i tried assigning
the valie to the text box that had
Me!txtMiles=Me!cboDestination.Column(2) but it didnt work. that was the
closet thing online i found that sounded like it might work. if anyone can
help please. this seemed like such a simple project but i cant figure out
what else to do

Reply to this Message