Form/Subform on a split database 1

[Shaz1]

Still stumbling.......

I have a split database with several forms for user data input.
In trying to create a new form with subform found that there weren't any relationships. Re-created the relationships so I could create the form with a subform data from two tables. The option (Form with Subforms)was not available from the wizard??

My quick solution was to saveas from an existing form/subform and change all the parameters so that the controls came from the correct tables.
In the subform I see #Name? in some of the fields. Any idea of how to rectify this problem?

 

[opvk]

The form fields that ia showing the #Name? means that it is not liked properly to the query. One way would be to open the form with the problems in the designer mode and when you click on the field list it show which table or query it is linked to. other wise click on the property box and in the data, u will find which query/table it is linked to.

BTW you will be able to find the subform in the toolbox.
I hope this will help you.



Winners don't do different things
They do things differently