Popup form is not loading foreign key

[Bkper087]

I've made many databases and maybe its just one of those days, but I'm going crazy.



I have a subform (Form B) on my main form (Form A) that includes a button. This button opens a pop-up window. The popup window (Form C) has a foreign key field.

Form B table includes FormBID (primary key) field.

Form C includes FormCID (primary key) and FormBIDfk.

What do I need to do to get the FormBIDfk field to autopopulate with the contents of FormBID when the form is opened? FormB will always be open when FormC is loaded. There is a one to many relationship set-up between FormB[FormBID] and FormC[FormBIDfk]

Nothing is working.

[kd2017]

I use OpenArgs.

DoCmd.OpenForm has an optional parameter OpenArgs. Pass your FormBID to the pop up form with this paramter.

docmd.OpenForm "form name here", , , , acFormAdd, acDialog, me.formbid

Then in form C's On Load event check to see if the form opened with OpenArgs, if so then set the default value of the foreign key field's control to the value passed to open args:

if not isnull(me.openargs) then
   me.formbidfk.defaultvalue = me.openargs
else
   'no args passed to form. clear default value just in case.. maybe not necessary
   me.formbidfk.defaultvalue = ""
end if

https://docs.microsoft.com/en-us/off...docmd.openform

[accesstos]

Take a look at the attachment (events.zip) of this post.
Maybe it covers your needs.

Good luck!