Combo Box A OR Combo Box B to pull up a record

[darth.pathos]

OK, I admit I should know this but it's been a long time since I developed anything in Access and well, I've forgotten quite a bit. What I'm trying to do is have a form where you can either put in the patient's Medical Record Number or their Subject ID for a study and pull up their information (the reasoning being that we need to convert from ID to MRN to request a chart, and then MRN to ID to fill in their information in our database). I've tried bound and unbound combo boxes, various pieces of VBA and SQL, all without luck. I won't embarrass myself (or waste your time) with the code I've attempted.

I appreciate any thoughts.

Thanks so much for your time
Chris

[mike02]

use an unbound textbox, in properties, data, rowsource, envoke the query builder.
Set up the ID, and your medical record number number to search on,
Note: you can have this correspond with a name to make it easier to search. (Add in the Name in the query, test the out put and make sure the numbers correspond correctly)
under the format tab in properties, format the column widths to hide the id numbers and only show the name.

In the form, under properties envoke the query builder. put all fields in the query and under the ID field type this in the criteria:

[Forms]![FormName]![ComboBoxName]

Hope this helps

Set a requery under after update on the combo box and that should do it

[darth.pathos]

Hi Mike,

I wasn't able to get Combo A or B working but your method worked for getting the one combo box up and running. I have now set 2 forms (MRN -> ID, ID-> MRN) with a button to the other on each form.

Thanks so much!
Chris

[mike02]

in the criteria part of your forms query, you can add multiple criteria.

So for the ID [Forms]![FormName]![ComboBoxNameA] OR [Forms]![FormName]![ComboBoxNameB]

try that,