Search results

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

Glad you have it working :D

Not sure that "MUST" is quite right. I thought that expressions without them would still work if the field name had NO spaces in it. I would agree that they are advisable though.

If you post a copy of the db one of us may be able to find the problem. The last code that I posted worked when I tested it.

Can you post a copy of the db with just a couple of fictitious records.