Search results

Hi I have a field in a table which is set to text, diplay control=list box, row source=value list. Row source = "level1", "Level2" etc up to "level9". Now the form for new records matches this except the values allowed are limited to the list, ie they can only enter exactly one of the list...

Hi The beginner here again..... How do I set a table to sort by specific fields??? ie i have an ID field which is an autonumber, then 6 fields I want the table to autosort first by a field called [rank], and then by a field called [name] Thanks in advance Egg

Hi All, I'm new here as I have only just started to use access :rolleyes: I am just creating a very small and simple database (one table, five fields) for personal use. My question is this: I have a text field called [rank] which is a list of predefined texts eg "level1", "Level2" etc etc...