Dynamic Form Control

[RT215]

I have a form that I want to create with a combobox for WorkOrder. When a
work order is selected, I would like for a textbox to display the product
number revision and description for that work order. I am creating a work
schedule that will automatically populate the remaining fields based upon the
selection of WorkOrder. The form will look like this:

Joe
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc

Bob
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc

Sue
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc
cboWO txtProductNo txtRev txtDesc

I cannot get the dynamic form to work with a subform or cboWO.coulumn(2), etc.

Any help would be greatly appreciated. Thanks!

Ryan

 

[Arvin Meyer [MVP]]

The column property will work. Did you change the ColumnCount property in
the format menu of the property sheet?

 

[RT215]

Thanks for the prompt reply, Arvin! It is still not working for me. I am
assuming that I need to put cboWO.column(2) in the control source for my
textbox, correct?

Thanks Again,

Ryan

 

[Arvin Meyer [MVP]]

Probably more like:

=Forms!YourFormName!cboWO.Column(2)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com