Hi,
I am writing code to save 57 fields to a recordset from a form.

Currently i am doing :-
product_code.setfocus
!productcode=product_code.text
Name.setfocus
!name=name.text
etc etc

Do i have to set focus in thsi way for every field?

ALSO if the !productcode was !product code (with a space) what is the correct syntax for that as !product code = product_code.text creates an error, and !product_code=Product_code.text doesn't work either

Thanks

Don't use .Text as it requires the control to have focus.
Just use !productcode=Me!product_code

So simple but so helpful, thanks very much