Search results

Why would he?

I wonder if the OP ever did read the link that Minty offered regarding cross-posting :unsure: 👋👋

The url for what and where did you try to post it?

If you could be bothered to read the links that Minty supplied, you might have more success.

Sounds like a job for DateDiff() function: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function To be of more help we'll need to know something of your table.

I shall remember the name "bmaccess".

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?