Objects

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
I had thought of that solution but, ruled it out. Would the DLOOKUP function
solve my problem?
 
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.
 
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
 
Okay, then the DLookup is the way to go. I would put it in the Form Current
Event"
Me.MyUnboundControl = DLookup("[FieldToShow]", "MyTableName", strCriteria)
 
Back
Top