Recent content by ThreeCrow

Give the attached a look see, it may help

Good catch, Fear Naught, miss it myself.

Put a Field in you table for the CheckBox, When you move to the next record the CheckBox changes to unChecked. You code is working fine.

That's about the max, Access does not larger fonts. You might try to merge you Fields to Word. You'll have a little more flexibility.

Something should happen even an error. Can you attach a striipped down of your dataBase zipped (100k or under)

To my knowledge no. I've tried to do and had no success.

What you want to do gets to be very complex, why not just create a Form with a subForm or listBox that show the same data as the Report. You would make the Form nonEditable. You could do Sorts and Filters on the data, to fit your needs.

Private Sub Form_Load() DoCmd.GoToRecord acDataForm, Me.Name, acLast End Sub

In your Query Design, on the tool bar you should see (middle) a ComboBox with the word "All" in it. Click on the down arrow. Select 10. The date Field should be first column of your Query

Have a method I think will work for your. Will need to see your Form and Report. Its a little detailed. attach a stripped down of your dataBase zipped (100k or under) or private email.

Put this bit of code in the OnClick property of you CommandButton. This assumes that your [YourRecordID] is numeric Private Sub cmdPrint_Click() If Me.Dirty Then ' Make sure the record is saved RunCommand acCmdSaveRecord End If DoCmd.OpenReport "rptYourReportName", acViewPreview, ...

Mark What is your end goal with this, is it for an Entry Form or a Report or the out sde chance Both. I've looked at your attachment and still (maybe its me) do not know what you want to do.

Give me some details about your Month Selection Form How do your CheckBoxes relate to the Month, are you going to want to use just the current year, or would want to select are year along with the Month. Do you have any of setup yet?

Taking for granted that this is all done on the same Form. ReQuery your ComboBox.

You could use an AppendQuery, based on the underlaying Queries of mainForm and subForms. But why are you wanting to duplicate Records.