Force form to recognize modified subform

[JR Hester]

Access XP on Windows XP
I am modifying an existing database for a slightly different use. Added two
fields to a supporting table, then added those two fields to subform.
Actually placed those two fields( call them Pretest and PostTest) between two
existing fields on the subform. I have two problems I can't get a handle on.
1. When I open the form containing this subform, the twio fields dispaly
onscreen to the right of the initial fields
2. Both fields display ?NAME in their control boxes. The control source
displays as tablename!fieldname.

CAn anyone point me in teh right direction to overcome these two frustrations?


Thanks for your help.

 

[Albert D. Kallal]

Open up the sub-form directly, do NOT open it up from the main form +
sub-form.


Try maximize this form in design mode, and then place/move around the
fields.....

Furthermore, using the view-field list to see the fields, and use drag&drop
to place the new fields on the form. If the fields don't appear in the
view->field list, then perhaps the forms datasource (query) needs to be
modified to add the additional fields from the base table (they will NOT
appear in the field list for the form if the form is based on a query..and
that query has not been modified to reflect the additional fields...)

 

[JR Hester]

Thanks for the reminder about my query, that was the source of the ?NAme
error and that is now resolved.

The position of the fields on the subform still remains stubborn. I have
successfully changed the location of the fields on the subform in design
view. The problem is that when this subform is opened directly or dispalyed
on it's parent form, the two fields added last appear at the right edge of
the data sheet, NOT in the order in which they appear on the design view.

OOPs, just found the cause. I designed this database many months ago. I had
set the DEFAULT VIEW to datasheet view. As soon as I wrote data sheet above
that triggered teh idea to check that setting.

Thanks again for the tip on adding those new fields to the QUERY and beinga
sounding board for the display issue.

The time and effort you put into supporting this forum helps all of us.

 

[Tom Wickerath]

Hi JR,

The position of the fields on the subform still remains stubborn.

The right-to-left order of fields in a subform is controlled by the tab
order. In form design view, click on View | Tab Order, setting the
appropriate tab order for each section.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________