T
Todd Dauzat via AccessMonster.com
Hello All!
I am new to Access and need some help. I am designing a search form to
lookup street addresses and to provide jursidiction information that is
listed in the table data. In my form header I have 4 text boxes to include
(the Street Number, Direction, Name, Type.) and a search button to the
right side of the form. When I hit the "Search" button, I would like it to
search the table information and display this information in the "Detail"
section.
In the form detail section, I have the same text boxes as above but have
included 5 more to display my information that is listed in the table data.
I also have 3 buttons 1) Clear All, to clear data from all text fields. 2)
Update, to update a record in the table and 3)Exit, to exit from the form
itself.
I have been trying to code this stuff myself but haven't been very
successfull. Any help would be appreciated or point me in the right
direction.
P.S. my Access version is 2000.
I am new to Access and need some help. I am designing a search form to
lookup street addresses and to provide jursidiction information that is
listed in the table data. In my form header I have 4 text boxes to include
(the Street Number, Direction, Name, Type.) and a search button to the
right side of the form. When I hit the "Search" button, I would like it to
search the table information and display this information in the "Detail"
section.
In the form detail section, I have the same text boxes as above but have
included 5 more to display my information that is listed in the table data.
I also have 3 buttons 1) Clear All, to clear data from all text fields. 2)
Update, to update a record in the table and 3)Exit, to exit from the form
itself.
I have been trying to code this stuff myself but haven't been very
successfull. Any help would be appreciated or point me in the right
direction.
P.S. my Access version is 2000.