Originally Posted by
AMJADJ
It is just a basic data entry form with 3 fields that then populate a table.
You said the fields are "vehicle id, storage and number of pallets". (I hope you didn't use spaces in the field names)
You don't have the date and time a truck was loaded?
Oops, then I see
One entry will be
order number,
vehicle number,
number of pallets and whether it is for
storage or delivery
Now it is 4 fields.
From Post #3
Originally Posted by
AMJADJ
I did create a table with one field called vehicle number, one form where the user enters the vehicle number (thus populating this tables field) and then make the vehicle number on the other form = the value of this field in the table
So now you have the vehicle number in a text box in the form header of the data entry form.
Have you thought about using the (data entry) form before update event to get the vehicle number from the text box control in the header and put it in the vehicle ID text box control in the detail section?
The code might look like
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.tbVehicleID = Me.tbVehicleNumber
End Sub
(you could also add code to ensure that the vehicle number text box in the form header is not null)
where Me.tbVehicleNumber is the text box control in the header that has the vehicle number (from the table)
and Me.tbVehicleID is the text box control in detail section that is part of the record with the vehicle id, storage and number of pallets.