Add a Table/Query to fieldlist on an existing Form

[mistertoony]

Hi,

I have a highly customized form that uses the field items from a single database. Is there a way to add additional tables/queries to this form, so that their field items display in the fieldlist?

-- Tony

[ADezii]

Hi,

I have a highly customized form that uses the field items from a single database. Is there a way to add additional tables/queries to this form, so that their field items display in the fieldlist?

-- Tony

I'm very hazy on your question, Tony. The Field List consists of Field Names that are contained within the underlying Record Source of the Form. To add Field Names to the Field List, you must manually or dynamically add Fields to this Record Source.

[mistertoony]

I'm very hazy on your question, Tony. The Field List consists of Field Names that are contained within the underlying Record Source of the Form. To add Field Names to the Field List, you must manually or dynamically add Fields to this Record Source.

Thanks. Under Form properties, the value for Record Source refers to a table in my database. Ideally, I would like the Record Source to contain values for two tables. Is this possible?

currently, Record Source - >Table1
desired, Record Souce -> Table1, Table2

[ADezii]

Thanks. Under Form properties, the value for Record Source refers to a table in my database. Ideally, I would like the Record Source to contain values for two tables. Is this possible?

currently, Record Source - >Table1
desired, Record Souce -> Table1, Table2

If the Tables are related via a Primary ==> Foreign Key, you can create a Query consisting of Table1 and Table2 joined with the Query showing all Fields from both Tables. You would now set this Query, instead of Table1, as the Record Source for your Form. Does this make sense to you?

[mistertoony]

If the Tables are related via a Primary ==> Foreign Key, you can create a Query consisting of Table1 and Table2 joined with the Query showing all Fields from both Tables. You would now set this Query, instead of Table1, as the Record Source for your Form. Does this make sense to you?

Thanks! That makes perfect sense; I'm on my way now. - Tony