Dynamic Default Values

[choward]

Hi Guys,

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!

 

[FoFa]

Use DLOOKUP against your query (I think you to preceed it with an =)

 

[choward]

Thanks FoFa - literally as soon as you posted that, i tested dlookup and it worked! thanks for giving me some assurance.