Subform question

[Hello World]

Hi everyone,

So far I have a form with a subform. The form itself is bound to a table and the subform is bound to a query. When you open the form you enter a number and click a 'Go' button. This then finds the relevant person in the subform and shows all their details on the one line in the subform.

What i wish to do in the main form is to add a 'yes' or 'no' to that persons record . This yes or no would then be put in the main table next to the persons name.

Is this possible?

[goodguy]

1. Modify your design of the table related to the main form to include the new field.
2. Open the form in design view
3. Display the "Add Existing Fields" window
4. Drag the new field from its table to the desired place on the form.

[Hello World]

Hello goodguy,

Thanks for replying! I'm using Access 2002 - i don't think it has the 'Add Existing Fields' window? Any ideas?

[goodguy]

[Show Tables] etc? In form and report design, you have an option to toggle Properties window. This is similar.

[Bob Fitz]

In A2003 this is done by selecting from the menu bar "View", "Field List" or by selecting "Field List" from the Form Design toolbox.