<div>
NotesTable has just 1 field &quot;Notes&quot;, I want the text box on the form to be able to write a new record to the field and also navigate thru all the records in that Notes field<br />
<br />
i'll do some googling on Dlookup and any other help you can give i will appreciate<br />
<br />

</div>


NotesTable has just 1 field "Notes", I want the text box on the form to be able to write a new record to the field and also navigate thru all the records in that Notes field

i'll do some googling on Dlookup and any other help you can give i will appreciate



<div>
Just curious, combo or DLookup?
</div>


<div>
<div class="content wysiwyg-content">
hi i have a db with a table named NotesTable and 1 field in that table called Notes....pretty simple<br />
<br />
i have a form called ProF and it's control source is a different table<br />
i want to put a text box on the ProF form that is linked to the Notes field in NotesTable while all the other controls on that form pull data from the other table<br />
<br />
i went into expression builder and entered [NotesTable]![Notes] as the control source but i must be missing some syntax because it doesn't work<br />
<br />
can someone steer me in the right direction?<br />
<br />
thanks<br />
<br />

</div>
</div>


hi i have a db with a table named NotesTable and 1 field in that table called Notes....pretty simple

i have a form called ProF and it's control source is a different table
i want to put a text box on the ProF form that is linked to the Notes field in NotesTable while all the other controls on that form pull data from the other table

i went into expression builder and entered [NotesTable]![Notes] as the control source but i must be missing some syntax because it doesn't work

can someone steer me in the right direction?

thanks



Expression builder in access 2007

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.