Dlookup Update

[Jonas]

I have a DLookup in a sub form that does not update when I move from
one record to another in the main form. I can get the dlookup to work
when I put the formula in the control source in properties but it
doesn't update. Which property would be used in this situation? Do I
have to do anything other than copy and paste my expression into the
code window so that I have destination.value=dlookup formula? Is
there a better method to use such as running a query given an event?

 

[Mike Painter]

I have a DLookup in a sub form that does not update when I move from
one record to another in the main form. I can get the dlookup to work
when I put the formula in the control source in properties but it
doesn't update. Which property would be used in this situation? Do I
have to do anything other than copy and paste my expression into the
code window so that I have destination.value=dlookup formula? Is
there a better method to use such as running a query given an event?

If there is a relation between the tables then that is always the better way
to go.

About the only place I use DLookup is in getting unrelated information.
I might have a "Company" Table that teh user fill in with the name address
and phone numbers and use that information in an invoice.

Even that's not really needed in reports as just dropping the fields on the
query builder and not relating it gives a Cartesian set and that is all that
is needed.