Search and Time Stamp

Hello,

I have just set up my first database in Access and I want to do 2 things that I am having trouble with.

1. I would like to create a search form, such that a user can enter in text and the result is a search through two tables that I’ve created: Chemicals and Source (They are linked: Source is a subform in Chemicals). The search would result in the “Chemicals” table that matches the search. If it is possible to show all the results at once, that is best. I don’t know much about code, so I need very explicit instructions/ directions.
2. In addition, I would also like to create a time stamp on a form, such that the date that particular entry was modified will appear on that form.

Please help. I’m having serious trouble figuring these problems out on my own.

Thank you,
Chem Geek

re: Search and Time Stamp

Hi,

For the first one you have to do a query to your tables... Type wildcard in Access and You will understand a lot about queries...

About the second:

In your form properies go to After Update event..

Type:

Me![Your TimeStamp]=Now()


Have a nice chance!

:)