Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

default value for data field ?

Status
Not open for further replies.

Parula

Programmer
May 10, 2001
18
US
Hi all

I have a simple question. If you have field in a table with the data type test but you used the Lookup wizard to create a drop down menu. I have six options on it but I would like one of them to be a default value.the six option i have are AN,FV,LP,BD,TY,AND IN, and i would like IN to be the default value. How did I do this?

Thank you
Paurla
 
Go into the table, highlight the field with the lookup and below the grid you will see the properties of the field. Set the Default Value = "IN".

Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top