Access 2016 - data entry form challenge - Microsoft Community

well. it's challenge me.

 

some of familiar civic association member database. through suggestions duane, scott, ken , tom, created table hold data regarding months members here locally or needed association mail sent alternate address. new table works charm mailing side of things.

 

it works great retrieving data within subform of master member information form. woohoo.

 

here's image of subform twelve months represented yes or no according members' "location".

 

my challenge new member data entry form. since there no existing records in tblpgimonths, subform displays default "yes" answer blank month. image below signature block.

 

how new member form prepopulate twelve months , default "yes"?

 

thanks.

 

dumfounded dan

 

run append query.

you didn't table design looks like, can give generic advice based on guesswork. first, need "tally table" numbers 1-12.

then need append query , select table append to. create 12 rows inserted selecting tally table on design surface.

for (what assume) personid field, can enter expression like:

forms!frmmembershipinformation!personid    (again, guessing @ exact names)

for inpgi field enter yes.

for date field enter expression like:

dateadd("m", tallytable!thenumberfield, date())

btw, have spelling error in title of inpgi column of form.

Office / Access / Windows 10 / Office 2016