Recent content by danbl

Thanks to everyone who replied! I checked the things you said and they were set the way you said they should be. The problem seems to be the control source was wrong!! How stupid on my part!!:mad::mad: I should have checked this first.

Okay …. I check that …. Thanks again , be back in a day or two.

Yes ….. I did checked that first … I feel I need to go back to the beginning with the form/table relationships and fields to make sure it is the way it is supposed to be. I will reply the first of the week after I take some time to insure it is as it should be. :unsure: Thanks for the help to...

Thanks for the reply! When I open the form independently, it is as expected. The form is set to visible = yes. But it maybe because the form control is wrong!!! 🥵😬 Need to rework this!!!

I have a Tab Control with five tabs with sub forms for data entry forms. These work as anticipated. I have tried to add a new page to the tab control and then added the sub form to the new page. The fields are visible in design mode but when you go to form view the new page with its sub form is...

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

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...

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.

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...

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???

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???

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...

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

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

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?