Question Find the data

asif pasha

Registered User.
Local time
Yesterday, 17:36
Joined
Jan 8, 2010
Messages
60
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.
 
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 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.
 

Attachments

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.
 
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?
 
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.
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom