combo box to fill in multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a schedule. I want to be able to select an assembly
from a combo box and have it also fill in the time per field, which is stored
in a assembly_info table. The catch is that I want the users to be able to
enter one time assemblies that aren't on the list and also enter their time
per. This means that I can't base the time per soley on a query of the
assembly_info table.

Any ideas? Thanks!
Chelsea_Bug
 
1) have the query for the combo box include the time as field 2 etc.
(change to be 2 fields and 0 length for second field)

2) in the afterupdate of the combo box update the time field (if it is
not locked they can then override it.)
me.timeperfield = me.combo.column(1) ' this is 0 based.
0 is first field 1 is second field, etc.
 
Back
Top