Pop up form - field not updated

Hello ... I have a Pop Up form imitated by a command button from a Supplier
form and a Supplier contacts sub form. The command button is on the sub
form. The Pop Up form should allow the addition of records to a "Supplier
Products" table adding records containing "Supplier index" (from the
Supplier form which remains open) and an entry from a products table (a
combo box).

I am having a problem getting the Supplier Index on the Supplier Product
table. I set the source property of this filed to:

=[Forms]![Supplier]![Supplier Index]

The field is correctly displayed on the screen, but the value does not
populate the Supplier Products table, the combo box entry works fine.

Any help would be most appreciated.

Abay

The controlsource must be set to the field in the table. Then set the
DefaultValue property for a new record to:

=[Forms]![Supplier]![Supplier Index]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Abay" wrote in message
...
Hello ... I have a Pop Up form imitated by a command button from a
Supplier form and a Supplier contacts sub form. The command button is on
the sub form. The Pop Up form should allow the addition of records to a
"Supplier Products" table adding records containing "Supplier index" (from
the Supplier form which remains open) and an entry from a products table
(a combo box).

I am having a problem getting the Supplier Index on the Supplier Product
table. I set the source property of this filed to:

=[Forms]![Supplier]![Supplier Index]

The field is correctly displayed on the screen, but the value does not
populate the Supplier Products table, the combo box entry works fine.

Any help would be most appreciated.

Abay

Hello again .. I figured it out .. set the default value of the field in the
form to: =[Forms]![Supplier]![Supplier Index], don't know if this is the
best way, but it works ..

Abay

"Abay" wrote in message
...
Hello ... I have a Pop Up form imitated by a command button from a
Supplier form and a Supplier contacts sub form. The command button is on
the sub form. The Pop Up form should allow the addition of records to a
"Supplier Products" table adding records containing "Supplier index" (from
the Supplier form which remains open) and an entry from a products table
(a combo box).

I am having a problem getting the Supplier Index on the Supplier Product
table. I set the source property of this filed to:

=[Forms]![Supplier]![Supplier Index]

The field is correctly displayed on the screen, but the value does not
populate the Supplier Products table, the combo box entry works fine.

Any help would be most appreciated.

Abay