force form to open...

[mjonson]

i open a form with the code

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "riskdetail", acNormal, , "tbl_risk.riskID = " & Me!rid

this takes the field id from a main form and opens the record in a form with more detail

the table relationship is a star layout

the problem i have is that the data has come from a notes DB and has holes in it.
if a record has all fields completed then the form opens with the data - but if there is missing data in the record then the form will not open (of course)

I would like the user to open the record and fill the empty fields - is there a way to force the form to open?

 

[mjonson]

right click join properties on 'sub' form query and choose option 2