Search function in an Access 2010 form where the fields are populated from the bound table

[krayav]

I created a form for some Liaisons to use when they visit Dr.s offices. They will visit many of the same Dr's offices over and over again so I want to them to pull up information from their last visit with all the contact information for the physicians.
I have my form split into two sections:
The first section has the name of the office, address, and other things that don't usually change. The second section has fields relevant to their current visit.
I want them to be able to search with the practice name and pull up, into the form, everything they did from the last visit. I already created a button to clear the second half once they have looked over everything they did during their last visit.
Any help is greatly appreciated.
I should also mention that I am new to Access so please be patient if I don't understand immediately.

[June7]

Finding the most recent record can be tricky. Options:

1 Domain Aggregate function DMax that pulls the latest date or record ID from the table for a patient and uses that as criteria to filter records

DMax("ID", "Visits", "PatientID=" & Me.PatientID)

that assumes the record ID is always increasing for each new record

or

DMax("VisitDate", "Visits", "PatientID=" & Me.PatientID)

2. TOP N qualifier in query http://allenbrowne.com/subquery-01.html#TopN

[krayav]

Thank you for replying.

I have attached a picture of the form I am talking about. I looked up DMAX but it looks like you have to write a code with the id number or the exact search field ( I could be mistaken). I would like the people liaisons to enter the practice name and pull up the information from the table. I'm okay if the search pulls up the table and they have to select the field to populate into the form.




Sorry if I don't get this immediately.

Thanks

[June7]

Yes, user can select the practice name and code will pull the last record for that practice - review http://www.allenbrowne.com/ser-62.html.

The Practice Site Name combobox can have the PracticeID as one of the columns. If you need to know how to build multi-column combobox, review http://datapigtechnologies.com/flash...combobox3.html

So the code to pull the most recent visit record for a practice could be like:

Me.Filter = "VisitID=" & DMax("VisitID", "Visits", "PracticeID=" & Me.cbxPractice)
Me.FilterOn = True

Controls used for input of filter criteria must be UNBOUND.