Okay, this is kind of a weird question that probably has an obvious answer. I'm making a form that allows me to enter new visits for a study that has multiple visits. For example, Study1 has visits: Day1, Day2, and Day3. I have a form called "addnewvisit" that has a combo box for Study (pulled from TblStudy) and then a textbox for Visit (going to TblVisit). The combo box lists all the studies I have entered into TblStudy, which is exactly what I want. Then I free-type the visit(s), which is also what I want. The problem is that when I click "Add New Visit," the study name gets duplicated at the end of the study list. So, in TblStudy I now have Study1, Study2, Study3, then Study1 again (autonumbers 1-4). As you can see, it generates a new autonumber for the duplicated study. The visit(s) are entered perfectly into TblVisit, though, including with a corresponding autonumber (unfortunately, it uses the duplicated autonumber - in this instance "4" instead of the original "1").
My question is: how can I have the form enter the necessary information into TblVisit without adding new information to TblStudy? I have a different form that adds the study in, and that one is now working perfectly.
Here are my Form Data properties:
-
Record Source: TblStudy
-
Filter: *blank*
-
Order By: *blank*
-
Allow Filters: Yes
-
Allow Edits: Yes
-
Allow Deletions: Yes
-
Allow Additions: Yes
-
Data Entry: Yes
-
Recordset Type: Dynaset
-
Record Locks: No Locks
-
Fetch Defaults: Yes
-
Thanks so much for all your help, guys.