Search results

On my form have a status field with about 7 options to choose from a combo box, i have these values set in another table. What i would like is for my other field, which is a date, to automatically change whenever the status field is changed. So i know how long ago the status field was set. So...

yay, ive done it! Thanks for your help.

Thank You for your help

Can anyone tell me why I get a pop up asking for parameter value of fields I no longer have in my table? It says this when I open my form. I deleted the fields from my form but it's still asking for it. Can I stop this? Thanks

This is getting very complicated! :/

am i able to place the subform in my main form and have it only show history records for the current customer in the main form only? because right now it shows up but i can scroll through all other customers history enries too, i only want to be able to look through history for that one...

Thanks ill try this.... what does FK and PK mean?

Ive tried following the instructions on the link you have given me and it still wont work, i works if i press ctrl + G and type in the code and press enter, but it wont work fo me to put it on the form, i just get the error, its so frustrating! lol

i have created another table called History as i thought this would be better organisaion, but im baffled with the whole table relationships thing. Ive got a field named Comments in my main table but i dont understand how it works to make what i type into get stored in the history table

im trying to add this to my database in Access 2013 and all i get is he #Error, its driving me mad, can anyone help? ive done exactly what it says in tis tread.

I apologise if this is covered elsewhere, but i cant seem to find anything on this issue (maybe because im not sure what im looking for - im a complete novice!) Im attempting to create a customer database for my customers which also keeps a record of when my customers contact me. This feature...