Search results

I think everybody should be able to see now. Remember the saying, "Abandon hope all ye who enter here".

Post a copy of the db

You're missing two commas: DoCmd.GoToRecord , , acNewRecord

Can you post a copy of the db

Try <> instead

Does the report open ok if you use: DoCmd.OpenReport "rpt3", acViewPreview in the Immediate Window

can you open other reports in Preview

Perhaps the record needs to be saved before the report is opened. EDIT: Something like: If Me.Dirty = True Then Me.Dirty = False End Ifbefore the line that opens the report.

Can't see why the solution offered wouldn't work. Post a copy for us to look at.

Try: Forms![YourFormName].[YourTextboxName] = Me.ActiveControl in the AfterUpdate event of the second textbox. Substitute YourFormName with the name of the first form. Substitute YourTextboxName with the name of the first textbox. Both forms will need to be open.

what are the forms called?

I believe it can be done by setting the AllowAdditions property of the subform using the events that I spoke of in post#7 and also in the main forms on current event. See attached

Have you tried using the sub form controls on enter event and the after update event to test or an entry

Are you sure?

Not sure what you want a sample of but MS has a Student template file. Post a copy of your db if you want an example of how you might flag a record.

Perhaps you can post a copy of the db

With a better understanding of the requirement I also tried the function way, as suggested by Gasman. My version of it is attached.

So, I'll ask again. Can you post a copy of the db.

I had no GroupBy clause either

Can you post a copy o the db