Hi
I am new to MS Access 2007 and needs the help for below scenario.
I have created a table (Contacts) with few details like FullName, FatherName, DOB etc. I have also created a form (Contacts Form) based on this table.
Now what I want is a blank form with only search field on it. User will put the text on this search field and cllick enter. on pushing enter, 'Contacts Form' should get open based on the search.
For example I have database with 4 names; A,B,C and D.
on the search form user will put B in search field and click enter, on OnClick event 'Contacts Form' with details of B should come up.
Now for search I am ok with combo box. So what I tried is creating a combo box with control source as FullName on a blank form. on OnClick event of combo box I wrote the code for openeing 'Contacts Form'. This is just opening the 'Contacts Form' irrelevant of the search entered.
Please help me with the same.
I hope I am not confusing all.
Regards,
Shreyesi
I am new to MS Access 2007 and needs the help for below scenario.
I have created a table (Contacts) with few details like FullName, FatherName, DOB etc. I have also created a form (Contacts Form) based on this table.
Now what I want is a blank form with only search field on it. User will put the text on this search field and cllick enter. on pushing enter, 'Contacts Form' should get open based on the search.
For example I have database with 4 names; A,B,C and D.
on the search form user will put B in search field and click enter, on OnClick event 'Contacts Form' with details of B should come up.
Now for search I am ok with combo box. So what I tried is creating a combo box with control source as FullName on a blank form. on OnClick event of combo box I wrote the code for openeing 'Contacts Form'. This is just opening the 'Contacts Form' irrelevant of the search entered.
Please help me with the same.
I hope I am not confusing all.
Regards,
Shreyesi