Sorting a form off a field with a DLookup in the control source

A

Alan DeHaven

I can't seem to do this.

What I'm trying to accomplish is to be able to give the dispatchers
immediate feedback as to when a truck could be expected back depending on
where they are sent to. I really don't need to store the ETA in a table,
it's just used for forecasting. What the DLookup up does for me is stamp a
time in the ETA field based on where the truck is going, FactoryPile, and
when it left, FactoryDepartureTime. The table "Trip Times" has and
estimated "Trip Time" which will be added to the FactoryDepartureTime once
the other fields are filled in.

=DLookUp("[Trip Time]","[Trip Times]","[FactoryPile]= '" & [FactoryPile] &
"'")+([FactoryDepartureTime])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup - double booking 4
update a field in a table 1
Count using a field of the form and looking into a database 1
Sortable form with join or dlookup 1
DLookUp on Forms 10
How do I use dlookup in a form to find a specific field 1
dlookup right from Help not working 2
Form-Lookup Values, Yes/No Fields, Etc.. 1

Top