Recent content by Rhodes7292

Ok, I have removed the Option Compare Database duplicated comment but it still doesn't work. Any ideas?

Hi Guys I am trying to place a Switchboard into my Access 2003 DB and have based it on the Northwind version with amendments to suit my needs. I have amended the code to reflect the forms contents but it keeps coming up with the error The Expression on click you entered as the event property...

thanks guys Is there anyway I can force the field to update, as I have to close after every update for it to register in the table

Access 2003 I am trying to save a calculated field (Item No) from a form to the accosiated field within the Products table I have a hidden text box (itemNo) which is bound to the relevant field and a second text box with the following formula ="TV-" & Left(CatShort.column(1),3) & "-" &...