Linked Forms Wizard

[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

 

[Lynn Trapp]

Is the query that your linked form is based on an updatable query?

 

[Gerry]

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"?

 

[Lynn Trapp]

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.

 

[Gerry]

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.

 

[Lynn Trapp]

Gerry,
Are you getting an error when you try to enter records in the linked form?

 

[Gerry]

YES!

Gerry,
Are you getting an error when you try to enter records in the linked form?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm