Searching the records in the Form.

[dsk]

Hi

I have a Form(ClaimPayment) which is assigned to a table in the database(ClaimPayment Table) as a Record Source. The Form loads all the records in the Table. There are around 1200 records in the Table.

The problem I have right now is that I need to search with in the records in the Form. I am not able to do it. I can do it manually but it is messing up the records in the database. I should be able to search with in the records in the form as it is difficult to search with in 1200 records.

So please advice me how to do the search.

dsk.

 

[jwindon]

There are several ways you can search. Do you want to search by a Claim ID perhaps? What is your primary key in the table Claims Payment?

Create a combo on your form. During the combo wizard, use the same table the form is based off of and select option 3 "find records based on my selection".

If that is not what your after, let me know.

 

[dsk]

Hi jwindon
Thanks for you reply.

I still have a problem.

I tried creating a combo box on the form with ClaimID which is the unique key. I populated it with the filed ClaimID from the table ClaimPayment. So when I ran the form. All the values are present in the combo box but they are not related to the whole record.

In the wizard I have two options in the first screen of the wizard.one is "I want the combo box to look up the values in the query or the table" and the other one is "I will type in the values that I want". So I selected the first one(I want the combo box to look...). After clicking next I chose the table "ClaimPayment". Then I selected the field "ClaimID" from the table. Then the width of the column. Then I selected the label Name and that is it. I clicked the "Finish" button. I am able to get all the values up. I tried the properties too. I could not find anything relative.

So can you suggest something.

 

[dsk]

I am looking for help for searching the records in a form in Access.

 

[pcs]

think you missed the correct option when you used the cbo wizard.

the wizard should offer 3 options:

I want the combo box to look up values...
I will type in the values...
Find a record on my form based on the value i selected...

you want the last one: Find a record....

delete your existing combo box and try the wizard again.

hth,
al

 

[dsk]

Hi pcs

I have only the first two options on the wizard of the combo box on my system. I dont have the third one as you are specifying. I only have two options.

I am using Microsoft Access 2000. Does version make a difference ?

dsk.

 

[pcs]

assuming your form is indeed bound to a table or query, it would appear that the version makes a difference.

but you need to verify that your form has a RecordSsource, if the form is "unbound" (no RecordSource) you won't see option 3 in the wizard! pretty certain that is the problem.

i don't (won't) use A2k...but don't think the version is the root cause of your problem.

check for the above, if someone doesn't jump in with the answer soon, i'll investigate.

al



[This message has been edited by pcs (edited 12-15-2001).]

 

[jwindon]

What I am thinking is this: Is there a field on your form (one of the bound fields) that is RELATED to the ClaimID. If there is no field to match, then perhaps Access already knows that the combo being formed and the form itself do not relate and does not give you the THIRD option.

What field on your form is related to your combo box?

 

[dsk]

Hi

Yap I had one more control assigned with the same field in the database(ClaimID). Now I removed it and I also have the third option available right now. I will try it and see what happens.

Thank you for the help.

dsk.



[This message has been edited by dsk (edited 12-16-2001).]