have you understood what the parameters are in your .open method
"openstatic" means precisely that
Id recommend you change to adopendynamic or adopenkeyset
if you are using unbound recordsets then you have to do the work in populating controls AND making certain changes are posted back tot he DB. bound controls do a heck of a lot for you, but there are not the solution for all/many situations, unbound controls are a great way of dealing with forms, but you loos most of the whizzy bits from the Access IDE.
yer pays yer money, yer takes yer choice