Recent content by danbl

  1. D

    Form sub form does not advance for data entry/edit

    Also when the master field and dhild fields are enabled the form disapears, is not visible
  2. D

    Form sub form does not advance for data entry/edit

    I have had multiple people assist me with questions and design of the forms mentioned in this post. I am By no means an expert and appreciate all the help I have gotten. Attached is a sample database for my question. I have a tab form as a sub form which consists of seven tabs and an example...
  3. D

    Solved Data Entry Form W/Subform Creates extra records?

    As far as the data entry goes, I believe this is now working as it should. THANK YOU VERY MUCH FOR ALL YOUR ASSISTANCE!!!:):) Many things have been learned in this process .... I will post the other issue as a new thread and hopefully will get this resolved. Thanks again.
  4. D

    Solved Data Entry Form W/Subform Creates extra records?

    I will post new thread for the form not showing issue. Why are you using a query with 3 tables as RecordSource? I thought this had been fixed from a previous thread, done now, all the tab forms relate to the appropriate forms for data entry. frmVisitE is associated with with a query as it is...
  5. D

    Solved Data Entry Form W/Subform Creates extra records?

    It seems that the data entry is working. However I have updated the interop form (frminterOpA) from the original form. When I added it to the data entry form it is not visible on the interop tab. When I added it to the form (frmVisitE) it is visible. How do I fix this???
  6. D

    Solved Data Entry Form W/Subform Creates extra records?

    I am TOTALLY, TOTALLY confused!!!! :unsure::unsure: When I tested this before sending it to you, I got a duplicate in the tables I mentioned. When I opened it this morning after seeing your reply, I tried it again and as you said I got only one record in each table. Any thoughts on how or why???
  7. D

    Solved Data Entry Form W/Subform Creates extra records?

    If I enter data using the form(s), when you go to the individual tables (preop, interop, postop) there will be two entries for one record entered?? I get what you are saying for the default value ... just didn't do that at this point. I opened the file I sent you and "vid" is the primary key in...
  8. D

    Solved Data Entry Form W/Subform Creates extra records?

    Changes made ...... still creates two records for the Preop, Interop, and postop...:unsure::cry:
  9. D

    Solved Data Entry Form W/Subform Creates extra records?

    Okay ..... will get this done and give it a try. I am sure I will be back with additional questions :) many thanks
  10. D

    Solved Data Entry Form W/Subform Creates extra records?

    This leads me back to one of my earlier questions. Does this mean that the larger Perioperative table should be divided into separate Preop, Interop, and Postop tables with vid as the foreign key in each?
  11. D

    Solved Data Entry Form W/Subform Creates extra records?

    I have created the new tables / queries / forms. When I open the forms they appear with all the questions as they should. However the preop, interop, and post op forms are not visible in the sub form. ??
  12. D

    Solved Data Entry Form W/Subform Creates extra records?

    Great ... I got one right :) The visit Id was what I thought I should use. I will work on this and repost later after I test with adding records again. Many thanks for the help as I learn along the way
  13. D

    Solved Data Entry Form W/Subform Creates extra records?

    Options 1 & 4 seem the most logical to me as I have no experience with code. Option 1 - this might be a large form that would require user to have to scroll through. Option 4 - would let me use the current forms and just fix queries etc. Each table would have a primary key. My question is if...
  14. D

    Solved Data Entry Form W/Subform Creates extra records?

    Are you saying your 3 distinct sections don't document the same kind of data? The questions are either Yes/No responses and if the question does not apply then the N/A field is selected. PQ1 and PQ8 and PQ15 aren't documenting the same thing? NO they are not the same. Each question is defined...
  15. D

    Solved Data Entry Form W/Subform Creates extra records?

    I have looked at the fields in the Perioperative Data table and don't see the repetitive fields you refer to. I can see were field descriptions may be misleading. I am not getting how adding the field Operative Type would solve the problem? :unsure: The table has three district sections with the...
Top Bottom