<div>
Thanks you all for assistance. I redesigned the forms in a more efficient manner. I am learning with your help.
</div>


Thanks you all for assistance. I redesigned the forms in a more efficient manner. I am learning with your help.

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have an unbound form with a bound subform. On open the subform shows 2 blank records. The subform is bound to a query that links the data to the main form via an ID. If I run the query alone i only get one blank line.<br />
Please help<br />
Thanks<br />
Iain
</div>
</div>


Hello,
I have an unbound form with a bound subform. On open the subform shows 2 blank records. The subform is bound to a query that links the data to the main form via an ID. If I run the query alone i only get one blank line.
Please help
Thanks
Iain

Bound subform showing 2 blank records on open

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.