Some help required on the form

[richardplr]

Hi.

I have a main form and a sub form. On the main form link with sub-form.

I have a field name PCNO and when I scroll with my mouse, it work and give me the data on the sub-form but if I enter it myself, it give me a message that duplicate value ,.......

Can you please try on the program call "stock receiving database" and at the main form, go to control PCNO. and key in 314 it will prompt you but if you use mouse to scroll. it ok.

Thanks

Regards,
Richard Tan

 

[Modesty_Blaze]

Can you give me some more info?

OK,
question one:
If you are trying to use this form as search form (when you enter value in PCNO form recognizes it as new record and couse it is set as no duplicates it gives you duplicate value thing) you will have to do something else. You can create a search form that will contain fields that will be basis for search and that will open Filtered 'Stock Receiving Database' (through query).

question two:
Am I on the right track, or it was something else that you asked???

that is it, for now...

 

[richardplr]

Re: Can you give me some more info?

OK,
question one:
If you are trying to use this form as search form (when you enter value in PCNO form recognizes it as new record and couse it is set as no duplicates it gives you duplicate value thing) you will have to do something else. You can create a search form that will contain fields that will be basis for search and that will open Filtered 'Stock Receiving Database' (through query).

question two:
Am I on the right track, or it was something else that you asked???

that is it, for now...

Hi,

Ya you are extremely right. So in this case what should I do. I have try to create combo as well but it not working.

But how to do it. Can you help me to do it on the attached program.

Thank you