Setting Default Value

[Ben]

Hi,

I have a form, that I'm using as an asset register. In it is a drop down
menu. I'd like to set the default value to the 1st record in a table, with
out having to do anything manually.

I.e. The table for os_type has
id type
1 -
2 Windows ME
3 Windows 2000
4 Windows XP

I'd like the drop down menu to be set to " - " by default, so that if I'm
adding a printer, I don't need to select anything from that box.

I tried entering "SELECT os_tbl.os_type FROM os_tbl WHERE id = 1 " in to the
default value box, but I get a syntax error.

Anyone have any pointers?

Cheers

Ben

 

[DubboPete]

Hi Ben,

Have you tried editing the table in design view, and for that field, set the
default value to

"-"

where the hyphen is surrounded by parentheses, aka "(insert hyphen here)"

should work....

DubboPete

 

[DubboPete]

Me again,

It's hard to illustrate using a hyphen, so I'll use your second option

Default Value = "Windows ME"

you choose the "hyphen" instead of "Windows ME"

hope that's clearer...

DubboPete

 

[Ben]

LOL, its OK Pete, I did understand the 1st time! Just tried it and it
worked!

Cheers

Ben