<div>
Right &gt;. Right Click ...<br />
<br />
mx
</div>


<div>
Thanks for the input. &nbsp; I'll try it and post back.<br />

</div>


<div>
<div class="content wysiwyg-content">
I've got a form with a field populated by a dlookup. &nbsp;There's an underlying field in the related table, but I'm not using that (I could).<br />
<br />
Right click on the field does not show sort ascending, sort descending, select etc. &nbsp;Ok, I kinda get it, it's a dlookup, so it's not simple to figure out how to do the sort.<br />
<br />
1) &nbsp;Will I run into the same restriction if I attempt to do an &quot;OrderBy&quot; on the field in vba?<br />
<br />
2) &nbsp;I assume that if instead of filling the form field with Dlookup I insert into the underlying table using sql, and then requery the form (which I have to do anyway, when the source field - in another form - changes), the sort should work?<br />
<br />
Thanks!<br />
<br />

</div>
</div>


I've got a form with a field populated by a dlookup.  There's an underlying field in the related table, but I'm not using that (I could).

Right click on the field does not show sort ascending, sort descending, select etc.  Ok, I kinda get it, it's a dlookup, so it's not simple to figure out how to do the sort.

1)  Will I run into the same restriction if I attempt to do an "OrderBy" on the field in vba?

2)  I assume that if instead of filling the form field with Dlookup I insert into the underlying table using sql, and then requery the form (which I have to do anyway, when the source field - in another form - changes), the sort should work?

Thanks!



Thanks for the input.   I&#39;ll try it and post back.


Sort on dlookup field in form

I&#39;ve got a form with a field populated by a dlookup.  There&#39;s an underlying field in the related table, but I&#39;m not using that (I could).

Right click on the field does not show sort ascending, sort descending, select etc.  Ok, I kinda get it, it&#39;s a dlookup, so it&#39;s not simple to figure out how to do the sort.

1)  Will I run into the same restriction if I attempt to do an &quot;OrderBy&quot; on the field in vba?

2)  I assume that if instead of filling the form field with Dlookup I insert into the underlying table using sql, and then requery the form (which I have to do anyway, when the source field - in another form - changes), the sort should work?

Thanks!



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.