How to set a default value in lookup

[lizzywu]

Hi there,



I tried to set a default value for a lookup list in a table by entering a value in Design View--General--Default Value. But that default value doesn't come out.

Does anyone know how to do it?

Thank you very much!

[boblarson]

Well, the best practices way to do things is to not use lookups at table level. Get rid of them - quickly! See here for why lookups at table level are not good:
http://www.mvps.org/access/lookupfields.htm
You can use lookups on FORMS but don't use them in tables.

[lizzywu]

Got it. Thank you very much.