Subform not visible

[danbl]

I have two forms and I want form 2 to be a subform of form 1. I have placed the 2nd form on form 1 as a subform and can see all the elements form 2 in design view but when I switch to view I can see form 2 header but none of the elements of form 2 are visible. Can someone help me figure this out??

Thanks

 

[boblarson]

I have two forms and I want form 2 to be a subform of form 1. I have placed the 2nd form on form 1 as a subform and can see all the elements form 2 in design view but when I switch to view I can see form 2 header but none of the elements of form 2 are visible. Can someone help me figure this out??

Thanks

1. Make sure that your subform recordset is updateable. If it is not, and there are no records in the table, it will show nothing.

2. If the recordset is updateable, make sure that the AllowAdditions property of the form and the main form are set to YES.

 

[danbl]

Bob,

Allow additions is on in both forms. Where is the updateable field found? Wehn I go through the properties I see nothing like this?

Remember I am still a newbe at all of this.

Dan

 

[boblarson]

Bob,

Allow additions is on in both forms. Where is the updateable field found? Wehn I go through the properties I see nothing like this?

Remember I am still a newbe at all of this.

Dan

It isn't a property. It is the record source of your form (find the form's RECORD SOURCE property under the DATA TAB in the properties dialog). So, if you can open the recordsource of your form directly and add a new record then it is updateable.

 

[danbl]

I can enter data in both tables or forms directly. The forms each enter data into two different tables respectively. Both tables have DOB, Date, and Physician in common. The one to one relationship between the tables is Date. Does this help?

 

[boblarson]

I can enter data in both tables or forms directly. The forms each enter data into two different tables respectively. Both tables have DOB, Date, and Physician in common. The one to one relationship between the tables is Date. Does this help?

So the record source is a table in each instance?

So, it is possible the Master/Child links are not set properly.

Also, you shouldn't use DATE as a field or object name because that is an Access Reserved Word and can cause you problems.

 

[danbl]

You are right the record source is a table for each form.

Date comment ... noted can change this if necessary?

Where might I find the Master/Child setting?

Thanks
Dan

 

[boblarson]

Where might I find the Master/Child setting?

Open the main form in design view.

Click on the subform control (control which houses the subform on the main form - for a screenshot, look at the first screenshot at this link).

Look on the DATA TAB of the properties dialog.

 

[boblarson]

Also, why do you have two tables with three common fields? You should really only be storing data once and have an ID which links the data.

 

[danbl]

Bob,

To answer your question about the 2 tables with 3 common fields ... A stupid oversite on my part but the second table was an add on later in the developement of the data base. I realize this would have been much simpler if I added it. Many queries and reports have been created since so it begs the question to redo all of those queries and reports.

Looked at your link and checked all the fields as compaired to the link. Still does not show the form except in design view. ??????

 

[boblarson]

Can you upload your database (but with BOGUS data)?

 

[danbl]

I can delete the data as I am working in a copy of the original. My goal is to get the data entry to work. I think I remember how to upload here but alternately can I zip it and email it to you directly?

 

[boblarson]

I can delete the data as I am working in a copy of the original. My goal is to get the data entry to work. I think I remember how to upload here but alternately can I zip it and email it to you directly?

I'd prefer it uploaded here because I can't access my personal email at work (except on my cell phone and that does us no good).

See here for how to upload.

 

[danbl]

Okay .... give me a couple minutes to clear the data.

Thanks Bob

 

[boblarson]

Okay .... give me a couple minutes to clear the data.

Thanks Bob

You should use my Database Reset Tool. It clears out the data in milliseconds.

 

[danbl]

Bob

Okay I went through the upload ... it is called "copy of database".

Thanks again.

Dan

 

[boblarson]

Bob

Okay I went through the upload ... it is called "copy of database".

Thanks again.

Dan

Doesn't appear to have worked. Did you make sure to run COMPACT AND REPAIR before zipping? And did you zip it and was the file size 2Mb or under?

 

[danbl]

Bob

Did you get the upload?
In the forms tab you will see the form I am using .... labeled in the propety section

Dan

 

[boblarson]

Bob

Did you get the upload?
In the forms tab you will see the form I am using .... labeled in the propety section

Dan

You would know if the upload occurred. It would show a link to the file right on your post.

You need to make sure when you open the MANAGE ATTACHMENTS that you select the file and then click the UPLOAD BUTTON and then the link should appear right there under the browse area of the MANAGE ATTACHMENTS pop up. You can then close that, but if the file does not appear there then it did not upload.

 

[danbl]

Did notice the message that the file is 2.72 which exceeds 2.0

Will strip some more out and try again!!