Change caption on continuous subform

[R Fourt]

I wasn't able to find an answer that works for this one. I have a subform
that is a continuous form and displays two records ONLY. The main form shows
a patrol car, beat assignment, etc and the subform shows the officers
assigned to that car for that shift, etc. Each officer has different
statistical data that will be entered into the subform.

On our paper form we have a section for "Officer #1" and "Officer #2". My
subform works fine but I would like a caption on my subform that matches the
paper form, i.e., Officer #1 on the first record of the subform and Officer
#2 on the second. I just can't seem to make it work. I'm sure it's because it
is a continuous form.

Any thoughts?
TIA

 

[Dorian]

Did you try setting Me.Caption = "caption" then refreshing the form?

-Dorian

 

[Mike Painter]

I wasn't able to find an answer that works for this one. I have a
subform that is a continuous form and displays two records ONLY. The
main form shows a patrol car, beat assignment, etc and the subform
shows the officers assigned to that car for that shift, etc. Each
officer has different statistical data that will be entered into the
subform.

On our paper form we have a section for "Officer #1" and "Officer
#2". My subform works fine but I would like a caption on my subform
that matches the paper form, i.e., Officer #1 on the first record of
the subform and Officer #2 on the second. I just can't seem to make
it work. I'm sure it's because it is a continuous form.

Any thoughts?

Since the same officers are probably not #1 and #2 all the time, it would be
awkward to put it in the record.
If it's a chain of command thing then you would want this information and
use a combo box to pick them. (It probably could be done as you assign the
record.)

If neither apply then I'd suggest a label alongside the subform.

 

[Paul Shapiro]

The officerNumber should be data in your table, and then it will appear on
the subform. If the main form is based on a CarShift table, or something
like that, presumably the subform is based on a CarShiftAssignment table,
with fields something like (carShiftID [FK to the CarShift table],
officerNumber, officerID [FK to the Officer table]). If the BeatAssignment
table has officerID1 and officerID2 fields, you would do better to change
the table design before going much further.

It would be easier to make suggestions if you can provide the relevant table
designs.