Hi,
I'm new to Access so I need a little help figuring out how to go about this. I've been experimenting with various forms and can't get it right. What I have is a table with address records. The user will be adding records to the table, but first he needs to manually check for duplicate entries. I would like a form in which the user can type in some textboxes and/or select from combo boxes to narrow the search down to whatever records match his entries. This could be a very broad search or very narrow, depending on how much information he fills out. I would like the results to appear in a table, like in a split form. The user can then evaluate whether his entry is already there or needs added. If already there, he could select the record (double click?) and edit it in a subform. If he determines that his information is not already in the table, then he can fill in all the pertinent info and add the new record.
I have succeeded in making a simple search form, and I've messed around with split forms a little, but I haven't figured out how to do all the above. Could someone point me in the right direction?
Thank you.