Insert field from table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie - 18 May 2007 15:27 GMT

I am trying to insert a field from a table, however I do not have that table
as the source for the form. This is from a separate table that I just want to
add to this existing form.

Since I only want one field from the table, I do not want to add a subform
that shows the whole table.

Any suggestions? Thanks!

Reply to this Message

Carl Rapson - 18 May 2007 16:24 GMT

>I am trying to insert a field from a table, however I do not have that
>table
[quoted text clipped - 6 lines]
>
> Any suggestions? Thanks!

Add an unbound textbox control to the form and populate it with DLookUp in
the Form_Current event:

textfield = Nz(DLookUp("[field]","[table]","criteria"),"")

Nz is needed in case the field is empty; you can't assign a Null value to a
textbox control. Be sure to use your own control, field, and table names.

Carl Rapson

Reply to this Message