Linking field from other table

[outlaw318]

I have a number field from "table A" that gives a dollar amount. "Table B" needs to use that field as a starting amount to calculate the overall total. I can't find the correct expression to link a text box to that field from "table a". I can't connect the two using a query because when a new record is created the the default returns to 0.

 

[FoFa]

I usually have just use a dlookup to stuff it in when whatever field on the form is filled in (lost focus event usually) that ties the tables together. So when whatever on the form is complete to make that tie to tableA, go get the value and stuff it in.

 

[dcx693]

I can't connect the two using a query because when a new record is created the the default returns to 0.

Can you explain more about this?

The Dlookup, which FoFa suggested, just that in some cases it can be slow to calculate. If we're not talking huge amount of data, you should be fine with it.