DLookup

[infosec]

Need help
I have 2 tables 1] tracker, 2] Reports . in reports I have 2 columns report_name and Frequency.I created a unbound form and use the Dlookup function to autofill the frequency when someone picks a report name. It works great. but does not populate the table "tracker". it populate every other field except the calculated field. here is my code;

=DLookUp("Frequency","tracker","Report_Name = '" & [Report_Name].[Value] & "'")

 

[boblarson]

1. control sources not bound to a field will not save data to the table. Calculated controls are such.

2. You shouldn't be storing this information again anyway. If it is already stored in one table, you should just get it with a query when you need it. Think NORMALIZATION.