Search results

Here is my database. I would appreciate any help you can offer on this. I used to do this with no problem on Access 2003 but a lot of things changed with Access 2007. Thanks again!!!

Thanks Paul for your kind reply. I double check the combo box and the ControlSource is currently set to blank. What about the RowSource? It is simply set to a query named qryDemographics. Is that okay?

I have an UNBOUND combo box called cboSubjectID (text format) on a form that I am using to look up existing record. Under AfterUpdate event, I wrote following code to try to do this but does not work. Private Sub cboSubjectID_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone...

Mr. B, Thank you for your help. The value is now passed from frmDemographics to frmHealthInfo but they do not get stored in the tables. What should I do?

I am building a database for a school project. The database contains forms frmDemographics and frmHealthInfo and they are linked to tblDemographics and tblHealthInfo, respectively. tblDemographics store patients information while tblHealthInfo store information about how they search for health...