Search results

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

I notice that you are using "Lookups" in your tables which can lead to problems. See: http://access.mvps.org/access/lookupfields.htm

Perhaps you could use a query to calculate the count of weekdays. Something like: SELECT Count(YourTableName.FieldNameToCount) AS NumOfWDays FROM YourTableName WHERE (((YourTableName.YourDateFieldName) Between [Start Date] And Date()) AND ((Weekday([YourDateFieldName]))<>1 And...

You could add a "LeavingDate" date field to one of your tables.

What's that all about?

Cross-Posted: https://www.accessforums.net/showthread.php?t=88649 Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

Search YouTube for videos on: "access table relationships". There are lots of them. Here's one I found:

I would advise against the use of Lookup fields in tables. See: http://access.mvps.org/access/lookupfields.htm