Dynamic Default Value

[choward]

Hi Guys (i posted this in the VBA part - but realised it's more appropriate here),

quick question - i'm a bit of a noob when it comes to Access so this might be really easy.

I am trying to set a default value of a field to be the most common value within the table.

Any ideas?

I have built a query to find the most common value but when i set the default value of the field on the form to be:

[Query1]![Most Common Value]

but it doesn't work. i get #name#? for the field value (although the query works fine in isolation)

Thanks!

 

[choward]

Hi Guys, i have just solved it. For those who need to know also - make the default value to be:

=dlookup("[result]","query_name","criteria=#")

Damn, that was so obvious!