New Record Not Showing Up

debo33

Registered User.
Local time
Today, 16:52
Joined
Aug 8, 2003
Messages
18
My goal is to create a new record(ID#) appear in both tables. What should I do? Or, should I do something totally different?

I have a form/subform (one-to-many relationship) linked by ID. The subform is set to 'continuous'. When I add a new record on the form, I can see it on both form/subform. The new ID# appears in the table related to the form, BUT the ID# doesn't not show up in table related to the subform.

debo
 
debo,

Are you using the Master-Child means of keeping your forms
in "synch". I would think not.

If not, you can make the [ID#] field on the subform invisible and
locked. No reason to see it, its on the main form. Set its
default value to:

=Forms![YourMainForm]![ID#]

btw,

It's a good idea not to use spaces and/or special symbols when
naming your fields, forms, etc. It will cause you more trouble
in the long run.

Wayne
 

Users who are viewing this thread

Back
Top Bottom