Pop up form - field not updated

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

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]
 
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
 
Back
Top