Change caption on continuous subform R Fourt 12/8/2008 1:43:21 PM 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

RE: Change caption on continuous subform Dorian 12/8/2008 3:23:16 PM Did you try setting Me.Caption = "caption" then refreshing the form? -Dorian "R Fourt" wrote: [Quoted Text] > 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

Re: Change caption on continuous subform "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 12/8/2008 5:18:09 PM R Fourt wrote: [Quoted Text] > 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. > TIA

Re: Change caption on continuous subform "Paul Shapiro" <paul[ at ]hideme.broadwayData.com> 12/9/2008 12:20:12 AM 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. "R Fourt" <RFourt[ at ]discussions.microsoft.com> wrote in message news:DC6A0DA5-8B53-4BCC-8D66-3A8B1D4A08F6[ at ]microsoft.com... [Quoted Text] >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.