Recent content by Askie

I have a form which is bound. There are three fields related thus: Impact - either 1,2,or 3 Urgency- either 1,2,or3 RAG - the product of above two (impact *urgency) How do I get the form to Save the calculated value without me having to manually put the result in the form field i.e. entering...

Bob I've tried the function but cannot get it to work using either of the options (AddRec, =AddRec) Also noticed that the function is ...NewRec.... so I changed to NewRec instead of AddRec, still no joy:(

Thanks Bob. The form is bound. So therefore the original solution of navigating to new record is the one. Since I would like this to be controlled by a button "Add Record" how do I navigate to new record programatically i.e. Code Such code would need to give me clear form when I first open it...

Bob Sorry but how do I establish whether the form is bound or otherwise?

Hi I am using Access 2007. Essentially what I am after is how I can get an input form to clear itself upon opening it then, after adding a new record again clearing itself down. I am relatively new to this so any help will be most appreciated