Subform completely disappears

[JenniferChapmanSleep]

Hello,

I created this database back in 2007 for a sleep clinic. We stopped using it and now I'm at a new sleep clinic that wants to use it. This ARNP is spending hours typing out reports from scratch every day.

There is a main form where I enter the patient's questionnaire and medications, etc.

Once completed with that, there's a button I made to go to the visit form. Within the visit form there is a neuro exam subform. For some reason the neuro exam subform disappears when I enter a new visit.

I can barely remember how I created this database. I spent hours and hours on the forum and copying and pasting visual basic coding... I have just lost it. I do remember this problem happening before and I think I fixed it just copying and pasting the records into a back up database.

Please help. I'll attach the database if you need me to. Thank you.

 

[Scooterbug]

Attaching the dabase will probably get you a quicker response. You can clear out any sensative data if that is a concern. (As you are dealing with Medical stuff...probably a good idea anyways). Let us know the form name that is causing the issue.

If you are using Access 2007, it would be best to save it as a MDB, as not everybody is running Access 2007.

 

[JenniferChapmanSleep]

MEH, I've compressed the database and it's still too big to upload.

 

[Scooterbug]

Did you do a compact and repair first?

 

[JenniferChapmanSleep]

Yep, then I sent to a zip folder and it's still 1.28 mb. I also don't know how to save it as an MDB.

 

[Scooterbug]

did you clear out the data? I dont use Access 2007 so I dont know the exact procedure for it...but I would assume it's under Save As...

 

[JenniferChapmanSleep]

I didn't clear out the data everywhere. It's actually Access 2002. Here it is. The form is called frm-ConsultInfoOnly and when you go into the visit form, it's labeled as EXAMINATION

 

[boblarson]

I didn't clear out the data everywhere. It's actually Access 2002. Here it is. The form is called frm-ConsultInfoOnly and when you go into the visit form, it's labeled as EXAMINATION

Since it is a split database, you would also need to include the backend database or else we are all dead in the water

 

[JenniferChapmanSleep]

That's weird... I thought I attached the whole version. Sorry about that. Here's the backend.

 

[Scooterbug]

Since it is a split database, you would also need to include the backend database or else we are all dead in the water

Uh....I got a bad feeling.....hopefully the data from the backend wasn't cleared out of the master copy...and if so....hope there was a backup....

 

[JenniferChapmanSleep]

Actually, I don't need any of the data... I have multiple back up copies. Thanks for your concern.

 

[Scooterbug]

whew

Well, the subform isn't "disappearing", it's just there is nothing for it to display. Your Master/Child link fields is VisitID. When you go to a new record, the VisitID hasn't been generated because no data has been entered.

Edit:
I Went through the forms (Visit, Next Step) and filled in some information. The query under your subform is not returning any records because there in no data in the tbl-ConsultTestInformation.

 

[JenniferChapmanSleep]

But even when I enter data into the visit form, it stays blank.

 

[Scooterbug]

If you open the actual query that the subform uses, you will see what I mean. Check the edited post...I have a habit of jumping the gun sometimes

 

[boblarson]

The problem is the underlying recordsource of the subform. Get rid of the extra table there and leave only tbl-ConsultTestInformation as the recordsource.

 

[JenniferChapmanSleep]

Wow! That worked! Thanks!

 

[boblarson]

Wow! That worked! Thanks!

Yep, no problem. Just try to remember that for subforms and combo boxes, etc. you don't need the extra tables in your queries. Just what you are using for the specific fields. This might also be of some interest to you.

 

[JenniferChapmanSleep]

Okay, that makes it easier. Thanks.

At some point I want to add a scheduling component to this database. That's going to be difficult for me, but I'll search on this forum for help. Thanks so much.

 

[gemma-the-husky]

the subform will disappear, if the recordset is not updateable or if you have set allowadditions to false, and there are no records

in that case, there are no records to display, and no possibility of adding a record - so the form is just blank - add the fields are actualy undefined, rather than null