Hi Guys,

Is there a way I can recreate the small search box at the bottom of my form within the actual form? (I'm on MS Access 2007)

The reason...
I have 2 tables. Table A has contact details, Table B has Call Logs, so..

Table A fields
ClientID
Name
Address
Phone Number

Table B Fields
CallLogID
ClientID
Date of Call
Details of Call

I have created a form which uses Table A as the main form with Table B as a sub-form so that I can view all call logs against a particular ClientID.

This works great, until I type another clientID number in the form then I get an error message about duplicating data. I get the feeling it thinks I want to change the call log data to a different clientID.

Now... when I use the little search box at the bottom of the form to type in the ClientID, it simultaneously fills the number in the Client ID textbox in my form, only this time it actually brings the new client records, I get no error. Which is why I would like to re-create that box somehow.



Any help greatly appreciated!!!!
Eric1066