Pop up form - field not updated


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
 
Ad

Advertisements

A

Arvin Meyer [MVP]

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]
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top