SubJeff on 31/5/2009 at 13:05

---

I've got a silly, silly problem in Ms Access.

I need to do that thing, you know the one, where you type in stuff in a form or a list (in Excel for example) and the software "remembers" what you typed in the same field last time and offers you your old options.

I'd call it autocomplete or autofill but googling solutions to for this in Access gives me details on how to do the far more complex autofilling/completing of ANOTHER field based on what you are putting into the current field. Yes, that is very useful and I'll need it one day, but not today.

I'm inputting hundreds of records, all fairly simple (10 small bits of data each, some of which are just yes/no tick boxes \o/) with the exception of the final field which is always a long technical description.

How do I get Access to auto-whatever it is?

I've set up a combo-box that queries the field in question so I can copy an paste descriptions from that but it doesn't update unless you close and re-open the form. Its a poor mans version of the auto-whatever (does anyone know what this is called?).

Any ideas how to do this?

Oh, version of Access I have are 2007 (desktop) and 2003 (laptop. I think it's 2003, its the one before 2007 anyway).

PS. I know I shouldn't really be repeating data like this if I want a fully normalised database. But I don't want a fully normalised database with this - its just one table and is essentially a fancy Excel sheet because I can run queries on it and get funky and meaningful graphs with more ease.