Can a field not in the Field list be added to a form after it's been c

[Xeseus]

I have spent some time creating a form with subforms from several tables. I want to add another subform that involves a tables whose fields are not currently in the Field list. Is this possible? If so, how can I do this?

 

[TheAceMan1]

How are ya Xeseus . . .

Hmmmmm . . . each form wether mainform or subform has its own field list as seen by the clicking the Field List

toolbar button.

[purple]Be more specific about what your trying to do?[/purple]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[Remou]

You can use the Subform control from the Toolbox to add a new subform. Make sure that the wizard (little wand) is switched on and it will guide you through adding the table and fields for your new subform.

 

[Xeseus]

It seems that what I need to create on my form is a search field made from a combo boxes rather than a subform. The primary key field I need for my Control Source, however, is not in the Field List. If I go to the Expression Builder to retrieve the field from a table or query I get a "Enter Parameter Value" pop up when I view the form. What am I doing wrong?

 

[ZOR]

Are your form/s bound direct to tables or bound from a queries, or unbound with code?

 

[Remou]

Have you tried using the wizard to create the combobox? In line with ZOR, if the form is bound, please post the SQL.

 

[Xeseus]

The form is bound direct to a table (if having a table in my Record Source implies this). I am not sure how to get to the SQL. I had tried creating a combobox with no avail, I was, however, able to resolve my problem by creating a query that had all the fields I needed and then making it my form's Record Source instead of the table that I had used as my record source.