update bound controls with query

  • Thread starter Thread starter Donovan
  • Start date Start date
D

Donovan

Here goes.
I am creating a form which tracks the scheduled and
actual times of aircraft launches. The scheduled times
vary upon the type of launch it is and on the actual
takeoff time for the launch. So far I have created a
table with all th different types of lauches. For each
launch there are a sequence of events. Each event is
scheduled for a time depending on the takeoff. The event
times are calculated by a difference of minutes. I have
also created a query which has a calculated field for
each field in this table. The calculated fields use the
AddDate function. When the query is run each field
subtracts the number of minutes for each event in the
table for each type of launch from a time specified on a
loaded form. The query works just fine. My problem is
adding the results of the query to a record in a
different table. I have created a form for this seperate
table which documents the sheduled times for a launch.
Can I imput the values of the query into bound controls
on this new form if it is not bound to the query. I hope
I am making sense and appreciate any help I can get.
Thanks.
 
I figured it out myself. I just ran an update query using
calculated fields based on a separate table. Updated the
form and viola new data.
 
Back
Top