Unanswered: Way to Automatically Enter a Field in a Subform
I am working on a form 'Cases' with a subform 'Procedures' that lists all the procedures for each case - this could vary from 0 to infinity. However, there is always one primary procedure - which is marked as a field of which only 'primary' or 'secondary' can be selected. Procedures is its own table.
Now, on the form Cases, I'd like to have a set of fields that they can enter Procedures data in but have it automatically select Procedure_stage=Primary. Perhaps with the caption "Enter Primary Procedure Here" Then another set of the same fields would automatically set this field as "secondary". Is there any way to do this?
I've set Enabled=no, and from a data entry standpoint it works, but when you view records, if there is only one procedure, it will list twice - once in the Primary section, and once in the other section.
To answer your question, I have two subforms - one with a default value of "Primary" and that field disabled. I have another subform (pulling from the same table) but with a default value of "Secondary" and that field also disabled. Entering data using these two subforms accurately labels them "Primary" and "Secondary", respectively. However, viewing these records presents this double listing problem. So even if a record is marked "Primary" in the table, it will still show up in both subforms.