Question Find the data

[asif pasha]

Hi,

I am looking for the field to find the data depending on the value i entered in text box.
For example : I have table containing - ID,Name,DOB,FatherName,MotherName etc.
And i want to place a combobox in the form containing the field contains in table(ID,Name,DOB etc). If i select a ID from combo box it should search the data on ID coloum viceversa and then display the record matching the entered value.

Please help me with this.

 

[DCrake]

Here is a demo of what you are looking for.

 

[PaulO]

Hi Asif

My approach would be something like this:-

1. Create a BLANK form with HEADER, DETAIL, and FOOTER elements
2. In the HEADER section of the form create a COMBO-BOX as you described and design/set it to capture the 1st Field (ID)
3. NAME the Combo-box as ID_Selector
4. In the DETAIL section of the form create a SUB-FORM based on your TABLE, this will need to contain all the FIELDS that you ultimately want to display
5. Open up the PROPERTIES of the Sub-Form and in the DATA tab you will see
   • Link Child Fields - enter ID
   • Link Master Fields - enter ID_Selector
6. You have now linked the sub-form to the combo-box such that any change in the combo-box should refresh the data in the sub-form
7. If there isn't an automatic refresh on change press F9

Hope this makes sense? Good luck!

 

[asif pasha]

Here is a demo of what you are looking for.

Hi,
Thanks for the reply. Unfortunately i am using Access97 version, if possible please farword me the 97version copy.

 

[asif pasha]

Hi Asif


My approach would be something like this:-

1. Create a BLANK form with HEADER, DETAIL, and FOOTER elements
2. In the HEADER section of the form create a COMBO-BOX as you described and design/set it to capture the 1st Field (ID)
3. NAME the Combo-box as ID_Selector
4. In the DETAIL section of the form create a SUB-FORM based on your TABLE, this will need to contain all the FIELDS that you ultimately want to display
5. Open up the PROPERTIES of the Sub-Form and in the DATA tab you will see
   • Link Child Fields - enter ID
   • Link Master Fields - enter ID_Selector
6. You have now linked the sub-form to the combo-box such that any change in the combo-box should refresh the data in the sub-form
7. If there isn't an automatic refresh on change press F9

Hope this makes sense? Good luck!

Hi,
I tried doing this, however when i linked the query in the subform, there is an error, please see the error print shot attached.

 

[asif pasha]

Hi Asif


My approach would be something like this:-

1. Create a BLANK form with HEADER, DETAIL, and FOOTER elements
2. In the HEADER section of the form create a COMBO-BOX as you described and design/set it to capture the 1st Field (ID)
3. NAME the Combo-box as ID_Selector
4. In the DETAIL section of the form create a SUB-FORM based on your TABLE, this will need to contain all the FIELDS that you ultimately want to display
5. Open up the PROPERTIES of the Sub-Form and in the DATA tab you will see
   • Link Child Fields - enter ID
   • Link Master Fields - enter ID_Selector
6. You have now linked the sub-form to the combo-box such that any change in the combo-box should refresh the data in the sub-form
7. If there isn't an automatic refresh on change press F9

Hope this makes sense? Good luck!

Hi,
I tried doing this, however when i linked the query in the subform, there is an error, please see the error print shot attached.

 

[PaulO]

Hard to tell what's causing that error ...

If the database is small, and/or you can ZIP it, attach it to your next post?

 

[asif pasha]

Hard to tell what's causing that error ...

If the database is small, and/or you can ZIP it, attach it to your next post?

I can't because the database size is 1.5MB.
If possible can you please convert the AutoFind database to a 97version. which is find in this query. So that i can try for this.

 

[Rabbie]

I can't because the database size is 1.5MB.
If possible can you please convert the AutoFind database to a 97version. which is find in this query. So that i can try for this.

Compact and Repair your DB and then use ZIP to compress it. If it's still too big then delete some of your data

 

[asif pasha]

Here is a demo of what you are looking for.

Hi Thanks..
I checked in office 2003. Its really amazing.
If possible please explain me how does it work.

 

[Rich]

Use the combo box Wizard and select the option Find a record on my form, the Wizard will do most of the work for you