How to have popup form autofill related field like subform does ?

E

envirographics

TblPeriodicalsBasics has PKey IDPeriodicals and relates to
TblPeriodicalContents on field IDPeriodicals. I found that whilst a
subform autofilled that field when data was entered in the subform,
having the form as a popup instead, seeing it was too large for a
subform, saw no entry into IDperiodicals occur in
TblPeriodicalContents.

You get to choose the two fields you want to relate together in pop up
wizard, but data entry does not fill in automatically the field
IDperiodicals in TblPeriodicalsContents.

I think you can keep popups showing whilst scrolling records and if
so, how do I get it to fill in IDperiodicals just like a subform does
?

I also would like to see some Main table data re-appearing in a window
in the subform but do I need to create a field for it in the sub-table
or can it be pulled in via code and a text box and exactly what should
code say and where ?

Coding newbie so if coding req'd for any of this then please type out
exactly what coding and exactly where please, best assume I'm thick !
Its so easy for coding not to work. I can replace field names with
mine but thats my lot !

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top