Search results

Yes the record is saved before the form is opened. Here is an example of what is happening: The user opens the Parent form and enters the info, then they click on a Child/Children button. If the parent has children already entered it will populate the child form with their corresponding child...

Thanks for the reply llkhoutx I however would prefer not to use a subform, because there is so much data that needs to be entered. It tends to get confusing puting that much into a subform.

I have a Parent form and Child form each with a corresponding table. The Parent table has ParentID as Auto number for the primary key, the Child table has childID as Auto number for the primary key and ParentID as the foreign key. The user enters a new parent or looks up an existing parent...

Thanks for the reply Fuga; I would however prefer that the Parent form be closed. Also, in regards to my initial question is this most logical approach I should take or should I approach this from another angle. Thanks

I wanted to get some advice on form navigation. Here is a very basic summary of my db. I have parent, child, and accounting tables, and each has a form for data entry. The Parent table has ParentID as Auto number for the primary key, the Child table has childID as Auto number for the primary...

I have a Client form and table with name, address, etc. as well as the services that they are using. I would like to be able to look up a service from the service table and fill in the related fields. I tried the wizard, but it only allows you to store 1 value in the db. Also find a record...