Pre-population of datasheet

[Yair Sageev]

Hi,

One of my forms needs to have multiple subforms in datasheet view. Each of
these datasheets needs to have the first two columns prepopulated with
values from values entered *once* in the main form. We only need to fill in
the columns 3 and 4. Is it possible to do this? Tips?

Thanks in advance.

 

[Yair Sageev]

Alternatively, the datasheet can be a list box. I am able to populate the
first column of the listbox, but not any of the others.