I hope this is the right place to post this ... but I am at my wits end after 2 days trying to figure out a small piece of code.

I have a Project table that records each project that comes in the office. I have a Tasks table that records each task for a given project with start dates and Due_Dates (Milestones).

What I am trying to do I thought was going to be simple.

When the Project Details form is opened there should be a textbox that will display the next Task Milestone date that is coming up. So I used the Dlookup to look for the next task date that was after the current date, that also matched the Project ID.