easy questions about access forms
Posted on 2006-10-31
Hi to everyone!
Here are some easy points for whoever answers me those 2 easy questions:
1.) I have set up a form and I have a column in my database which is called "Searchword" (let's say it's column #3). I would like to have a field in my form in which I would type the searchword and the other fields of the form would show me the whole information in the respective entry which I could later edit. How can I achieve that?
2.) I also have a field in this form (and a column in my database) where I manually typed the date of the last change in this entry. I would really like this to happen automatically, that is, I would enter a change in any field of my form and the date of change (shown both in the database and the form) should be set automatically to the current date.
Thank you all in advance!
P.S.: Or should I have probably posted my question in the MS Office category?