Recent content by reeseburg

I would expect this is an import issue from a database that provides HH:MM:SS. I run into this all the time. It's easy to do in Excel using the Year(); Month(); and Day() functions.

Thank you for the post

Thank you for this posting. That worked for me.

Got it. One more question. How do I get the answers to show up in the subform without pressing the Begin Review button twice? (when entering a new review record)

It isn't doing it on my screen. Which is the circular referencing line(s) of code? Is this the error check for a blank Review_ID field? Tim

Press Record Review on Main Menu. Select any of the fictitious patients or reviewers, then press "Begin Review".

Here is the database in all of its unglory.

It is populating a local table. Best way of showing you the process?

Working on the validation piece. If it's a new record, wouldn't the autonumber primary key field "Review_ID" in [tblRecord Reviews] be null? I then check to see that the record is not null (entry of any data in any of the form's controls creates a new record and subsequently, a valid Review_ID...

Your recommended code works and is incorpoartated. The intent is to create a list of review records for chart reviews. tblanswers are linked to tblreviews and tblquestions (so I can change the questions and use the record reviews for different areas of concern). When the user opens the form...

I'm working on a database that will review patient records with a series of questions. I have a form for a new review that contains a subform with the questions. The questions are linked to the review id, so when generating the questions, I need the insert the current review id into each new...