M
Midland
In the form I am working on, I have been using controls to pull up some
linked information so I have an immediate check on errors that might be in
the source data. For example, if I input a part number, quantity (of units
finished) and run time, the completion rate is a simple expression (qty/time)
that uses the numbers I just typed in.
Other references are not working so well. If I wish to pull up a standard
rate to compare to the calculated rate, I need to use the part number to pull
it off a separate table. I have created a InQry multiple-table query between
the form and the primary data table to link in the rate table, but the
Standard Rate control still does not pull the number I want immediately. What
do I have to do to make this happen.
Farther down, I have a "set up" control to add this number if needed, with a
default of zero. The next control, however, is for Downtime. I want that to
use the set-up time just entered as a default, butit will not populate at all
unless I type in a number manually. Is there a way to make the default for
this cell the value from another cell on the form?
linked information so I have an immediate check on errors that might be in
the source data. For example, if I input a part number, quantity (of units
finished) and run time, the completion rate is a simple expression (qty/time)
that uses the numbers I just typed in.
Other references are not working so well. If I wish to pull up a standard
rate to compare to the calculated rate, I need to use the part number to pull
it off a separate table. I have created a InQry multiple-table query between
the form and the primary data table to link in the rate table, but the
Standard Rate control still does not pull the number I want immediately. What
do I have to do to make this happen.
Farther down, I have a "set up" control to add this number if needed, with a
default of zero. The next control, however, is for Downtime. I want that to
use the set-up time just entered as a default, butit will not populate at all
unless I type in a number manually. Is there a way to make the default for
this cell the value from another cell on the form?