Default selection in listbox

[eric]

Hello,

I have a listbox of years. For example:
1999/2000
2000/2001
etc.

I would like to default to a specific year each time the
form is open. For instance, part of my years table has a
yes/no field as CurrentYear. I would like the list to
default to the singe record that has CurrentYear marked
as true.

Any ideas?

Thanks

 

[Dale Fye]

How about setting the controls default value equal to a DLOOKUP.

DefaultValue: = DLOOKUP("ID", "Years", "CurrentYear = -1")

--
HTH

Dale Fye


Hello,

I have a listbox of years. For example:
1999/2000
2000/2001
etc.

I would like to default to a specific year each time the
form is open. For instance, part of my years table has a
yes/no field as CurrentYear. I would like the list to
default to the singe record that has CurrentYear marked
as true.

Any ideas?

Thanks