Recent content by AndyEd08

What is the background for all you access "guru's". I really enjoy playing around with it but want to get more serious with it...where would I start...the OU is quoting a computing degree, text books quote the MCAS??? I would also like to go the whole hog and get my teeth into VBA properly.

It's still not working, although I can sense that this should be so straightforward...Perhaps if I define the setup... I have a series of fields within a tabbed control, each holding information about a property. I would like to set the ID field up using the last 3 digits from the "Postcode"...

I've substituated that code but now I can tab onto the next field WITHOUT the "PropertyID" field updating??

Nope, that didn't work either....

Hi thanks for the response. I'm a complete newcomer to this...so it's doubly frustrating although brilliant when it goes right. I've omitted the .Text references but the same happens....!?!

I have inputted the following code as an "After Event" sequence on a form which should cause a field entitled "PropertyID" to be filled with a string comprising of elements from 2 other user inputted fields. It is not working however, displaying the following message: "Run-time error '438'...