Having subform show existing entries in edit mode?

[maxxev]

Hi,

I have a form: "frmIngredients_Editable"
Table behind this form is: "tblIngredients_Table"
Primary Key: "Ing_CodeID"

This form has a sub form: "frmIng_Spec_in_use Subform edit"
Table behind this form is: "tblIng_Spec_Detail"
Primary Key: "Ing_SpecID"

These two tables are linked by: "tblIng_Spec_in_use"
Which has both of the primary keys for the above tables and the primary key of: "Ing_Spec_in_use_ID"


I want the subform ("frmIng_Spec_in_use Subform edit")
to show exisiting specifications as well as allowing users to associate a new specification with the ingredient.

Yesterday I got help to do this on a linked form, now I would like to know how to do it with a subform.

Thank you

 

[MajP]

This is a standard form - subform set up. You can use the wizard to set this up. Or in the subform control look at the
link master
link child
properties.

 

[maxxev]

Nope

I have 2 identicle forms one has the form open in .. erm non-edit mode and it shows pre-exisiting entries.

However the identicle sheet that has the form in edit mode, thus allowing new entries WILL NOT also display exisiting.

I'm a basic user I did follow the wizards.

 

[postermmxvicom]

Have you opened the form and the subforms up in design view and looked at or changed their properties under the data tab on the property sheet? Specifically, the allow additions, allow deletions, and allow edits properties?

Also, are you using making a 'switchboard' interface...I think it changes these properties on its own...kinda bothersome.

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?

 

[maxxev]

Thank you for comments but i've sorted this now.

(I copied the read only one and fiddled with it's settings to allow editing).

Cheers