Sorry for the confusing title. Let me explain. I created an issue register type access database to have better communication between staff and technicians. I found a template that I have tweaked to better suit my requirements.
The startup form that the staff interact with looks like this , "Issue Details":
The form a technician views is the datasheet below, "Issue List":
When the ID number is clicked or the Title field is double-clicked, the initial startup form opens to the record pertinent to that ID field. So if I clicked ID 7, it will open the "Issue Details" form with the filled out fields. This is what I want.
But when the database opens, the "Issue Details" form is the startup form. So I don't want the fields to have any previous text filled (like shown in picture 2). I just want a blank form. But when I try to do this with:
It messes up. So when I click the ID 7 or 8 again in the form "Issue List", it opens a blank form.
How do I achieve the blank form on open, unless I click the ID field which will open the required row source in the form with the filled out text?
The startup form that the staff interact with looks like this , "Issue Details":
The form a technician views is the datasheet below, "Issue List":
When the ID number is clicked or the Title field is double-clicked, the initial startup form opens to the record pertinent to that ID field. So if I clicked ID 7, it will open the "Issue Details" form with the filled out fields. This is what I want.
But when the database opens, the "Issue Details" form is the startup form. So I don't want the fields to have any previous text filled (like shown in picture 2). I just want a blank form. But when I try to do this with:
Code:
DoCmd.OpenForm "Issue Details", , , NewRecord
It messes up. So when I click the ID 7 or 8 again in the form "Issue List", it opens a blank form.
How do I achieve the blank form on open, unless I click the ID field which will open the required row source in the form with the filled out text?