Windows XP 
Access 2003
Hi everyone, I hope you can help me out here!
some time back I created a database to help keep track of paperwork. It was crude, but worked well enough. Earlier today I was asked to add a few new fields to the database, and after doing so and updating the form used to display the information, I noticed something has gone wrong...
In order to pull up a specific record, I used a query with several user defined criteria. A user would click a search for record button on the switchboard form, this brought up a string of pop up boxes which users could either use or skip (Not very elegant, but it worked). The form produced would then only show records relevant to the user defined criteria.
Since the update, the database has stopped doing this. Now when the search is clicked the form simply opens, showing whatever record is first in the table, with no boxes for data input. It also brings up all the records in the table (the form is set out to only show one at a time).
The update was 4 new date fields and a check box in the table. I also added these fields to the query used to find a specific record for display. How can I get this system working like it was before?
All help very much appreciated, I am useding access 2003.
Reply With Quote
