Datasheet rippling through effect

W

Winnetou

I would like to create a form (in datasheet view) to post cooking
instructions to the kitchen staff.

Each item should be assigned cooking instructions if necessary. To
that effect, I created a cbo box (Kitchen) which accepts as rowsource
the contents of txtbox RowSrc. (Kitchen rowsource type = value list;
RowSrc will be hidden.) I am able to pull the contents of RowSrc into
the Kitchen RowSource. However, when I do so, any selected value, say
"reg.", ripples through the whole datasheet.

Is there a clever way to eliminate this?

The situation is depicted below. If I select "reg." for item Caesar,
"reg." is displayed across the whole datasheet.

Item RowSrc Kitchen
Caesar reg.; dr. sd.; no cr. reg.
NY Steak rare; m.r.;m.;w.d. reg.
Coffee reg.

Thanks for your input.

Mark
 
Top