Made a Mistake, Please Help!!

I believe that I was in the Form Properties when this happened. When viewing my forms, I can no longer see the data entry fields in the subform, but I can see them while in design view. I have been trying to figure this out for an hour now, and I cannot find it!!

Thanks,

Chad

In the design view have you changed the visible property to No in the form or detail properties of the Sub form

S-

They are both set to yes. I am still trying to figure this one out.

Any other suggestions?

Thanks,

Chad

This is just a shot in the dark. Do you have a picture or background of some kind in your form? It's possible the data entryfields are behind something. It would have the same effect as a piece of paper on top of another piece of paper. You know there's more the one page you just cannot read it until you bring it to the front. If so, open your form in design mode, click on the pictrue or background then click the menu item FORMAT and choose Send To Back. You may want to select your data entryfields and then click FORMAT > Bring To Front. It's the only thing I can think of if the data entry fields are in your form in design mode and the properties are set to visable.

HTH
Marty

I do not have any pictures but I tried that anyway and it did not work either. This happened on both of my forms that have subforms if that will help.

Thanks,

Chad

If you have a query attached to the forms, open the query seperately to see if you get any info showing. If you do get some from the bare query, you may have got a link problem with the subforms.

Roger

I am not sure what you mean by "info", but I have not entered any data into the table that the subform is associated with. I can see all the feilds when I open the query.

I was going to attach screenshots of the forms and there properties so you know what I am talking about, but will not let me upload a .doc file.

Thanks,

Chad

Chad,

If you have a query that selects data from your tables to populate your form, try to open the query and see if you get the data that you wanted to see. If you don't get the data, then there is something wrong with your query (probably a relationship problem) and this could be the reason why you are not getting data into the form.

If you are getting data, then you may have changed the link between the master and subforms somehow.

Roger

I figured it out finally!!! What I did was set the "form" property "allow edits" to no so that when a user was scrolling though the records of clients to find the appropriate one, they would not be able to change the name of the client. When they find the client, they can then add an event in the "subform" fields. If I set the "allow edits " to yes, then the empty fields are available so that I can put data into them for a new event. But then the user can edit the name fields in the "form".

Am I doing this right, or is there a better to do this?

Thanks,

Chad

Sorry for the previous post.....It was the "allow additions" property that was set to no. I think I was getting the form and sub-form properties mixed up. Should have a handle on it now.

Thanks,

Chad

It's just to share my experience that if your form's AllowAdditions property is set to False and no records in the underlying table/query then the form will not show any controls.

If you don't want to allow additional records when you open the form you can check the number of records in the form's recordset and if it's 0 then set AllowAdditions to True otherwise set it to False in the OnOpen event.