Linked Forms Wizard

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

I'm having a small problem with the forms wizard.
After i have selected my two linked tables the form Wizard presents
me with an option to creat a Subform OR a Linked Form.
When i select the link option it creates the forms just fine.
When I click the button to open the linked form, if there are existing
records that are infact linked, the Linked formshows them.
HOWEVER I can't ADD new records in the linked form.
Is there a known problem with the Wizard.
PS. I am using Access2000
 
Thanks for the quick response Lynn,
to answer your question...
I don't know.
I used the form wizard- Selected first table & all it's fields
then selected second table & all it's fields. Then the Wizard created
the Main Form with a button to link to the second form.
I let the Wizard do all the work.
How can i check to see if the linked form has an "Updatable Query"?
 
Well, first you need to determine whether you had the wizard use a table or
a query as the record source for the linked form. Second, you should check
to make sure the Allow Edits and Allow Additions properties of the form are
set to Yes.
 
Hi Lynn
I selected the two TABLES in the Form Wizard.
The second form has allow edits and Allow additions.
I havn't changed anything at all.
Has no one ever tried using a linked form in the wizard instead of a
subform?

It works in every respect except when I try to add a new record in the
linked form.
My table relations are one to many
One being the table for the main form, many being the table for the linked
form.

If I use the subform method everything works fine.
I Can't figure out what might be wrong.
 
Back
Top