combo box to fill in multiple fields

C

Chelsea_Bug

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
 
R

Ron2006

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.
 
Top