Entering default values (1 Viewer)

[CoffeeGuru]

I have a 1 row table as a result of 2 queries that give me the 'MaxYear' AS 'DefaultYear' and 'MaxWeek' AS 'DefaultWeek' in that year for a selected retailer and stores, from a master table.

On my form
I want the default Year and Default Week text boxes to display the values of these

I have tried pointing to a table holds the results and pointing to the queries for each box

I have used Form.Refresh and Forms.Requery
but nothing picks up my values

Any ideas anyone.

 

[CoffeeGuru]

sort of SOLVED.....grrr
=DLookUp("[DefaultYear]","[tmpDefaultPeriod_0]")
=DLookUp("[DefaultWeek]","[tmpDefaultPeriod_0]")

Note to self: Dont forget the quotes!!

M

 

[CoffeeGuru]

UGH, I thought I had this solved but now I find it doesn't update, I could seriously cry....

If I delete and retype the above code it changes, How do I force it to reflect the change when another combo box on the form is updated?

M