Good morning, David-
I'd like to step back a bit and see if I understand what you want to happen. Then we can reconstruct the steps to get there. How does that sound? First, let me see if I understand what you've posted. Do please throw a sock at me if I've misread. :)
You have a form that displays workorders (WOJRN), which are ordered by work order # (WOJRN.WONO).
You have two comboboxes (cbo).
One cbo is used to select work orders to view.
The other cbo is used to pick an opcode from the opindex table.
When you make a selection from the WOJRN combo you want the form to refresh to show the selected work order.
When you make a selection from the WOINDEX combo you want the selected WOINDEX.OPCODE field value to be assigned to the WOJRN.OPCODE field.
Before I blather on < s>, please let me know if this correct?
>
Primary table: wojrn
>Orderered on wojrn.wono
>Primary combo rowsource is wojrn.wono
>Primary combo controlsource is None
>Primary combo Boundto is .F.
>
>Secondary table (R/O) : opindex - two fields, opcode and desc
>Ordered on opindex.opcode
>Secondary cbo has controlsource = wojrn.opcode
> rowsource = opindex.opcode,desc