Objects

K

Ken

I would like to add an object (TerminalRate) into my Form. However, this
object does not exist in my field list. This object exist in a table called
system. How can I reference this in my form.
 
K

Klatuu

Instead of the table as the record source for your form, use a query that
will include your current table and the table with TerminalRate in it and
include TerminalRate as a field in your query.
 
K

Ken

I had thought of that solution but, ruled it out. Would the DLOOKUP function
solve my problem?
 
K

Klatuu

If you don't need to edit it, you could do that. It will not be updatable in
the form; however, you could add code to write it back to the other table.

Why is it you don't want to create a query? That would be the easiest way.
 
K

Ken

My form is complex. It has subforms and elements that requires computations.
The Dlookup works and it computes correctly. I also don't need to edit this
element.
Thanks
 
K

Klatuu

Okay, then the DLookup is the way to go. I would put it in the Form Current
Event"
Me.MyUnboundControl = DLookup("[FieldToShow]", "MyTableName", strCriteria)
 
Top