Would like to start new records with PK

[JimJones]

Hello,

I think this is a subject issue which I've certainly help beat to death.

It was answered with previous help received here, when the issue at hand was "how to get my pop up form to match a certain field from the underlying form, with the help of a query". In that case, it was a query, which worked because it had data to retrieve and do what I wanted it to. That function still works beautifully.

But, I have a subform, and a brand-new table which we'll call "Details". The subform is Service, which gets its data from its own table.

OK. "Details" will be the many side of Service.
But to keep from getting the related record error, I'd
like for the table to be updated as soon as it is opened, with
it's many field to immediately reflect the PK currently displayed on the service subform.

Somehow, I don't think this issue needs code, but I could be wrong.

But I'd ultimately like the Details form to be a pop and to
get the data directly from the Details table, except that when
the Details form pops up, it's going to enter a new blank
record to reflect the PK from the subform. And, if I dont need
to enter data at that time, I can just hit undo, or whatever.

Can you help?

Thanks,
Jim

 

[WayneRyan]

Jim,

Get your form in design view. Right-Click on the subform and
put the field names in the Master-Child links. Then Access
will handle the coordination of your forms.

Wayne

 

[JimJones]

Wayne,

That would certainly work otherwise, but my problem
is that there's no room.

That's why I need to make this Details form a pop up form.

I almost got it working, but I still get:

You can't add or change a record because a related record is
required in table "Service"

And I know for fact that record exists in the subform.
I'm getting the number right from the form, as I want to !
But I still get that error !

Any more help on this?

Thanks,
Jim