'Search' type feature

[tdbeargrrl]

I will try to explain this as best I can. If more information or clarification is needed please feel free to ask.

I have a small database that is used by people who are 'afraid' of access. I am doing everything for them in forms - and I have learned alot in creating this many forms. Anyway my question - One of my users has to pull up information that was entered by the other users and the 'review' it and mark it as being reviewed. She needs to be able to pull up the records by either name or id number. She will select either name or id number and then enter the name or id number and display that patient. How do I do this? I feel like this should be fairly simple to do, but I just cannot wrap my brain around it today!!!

 

[thornmastr]

You will need at least a review flag in each record. If all you care about is that it has been reviewed, this can be a boolian value.

Yu might want to use a combo box in the header of your review form to let the user select the name of the patient they are going to review. You might want a two column combo box with the second column containing the id number. This probably should be an invisible column which will let you use it as the key of the record which you want to read.
You can use the forms detail section to display/edit the record to be reviewed. You can define the reviewed check box as invisible and set it to true in the forms before update event.

If you need more help, let me know.

Robert Berman