Lookup Fields - Evil Access Stuff

Relational Combo

I will fix the transaction table
Thanks

In my case , if duvett is already sewed all but there come up again the same CODENUMBER , how to tell user not to add

Hi Liem, Kevin's advice is always to be listened to. He knows what he is doing. I am going to upload 3 screen clips that demonstrate a many to many relationship. Take a look. HTH John

How to tell the INPUTTING DATA if DUVETT ,for instance, has been sewed all so NO INPUTTING THE SAME CODENUMBER any more.
How to create a warning I mean

If Doe has done all the duvett and the inputting data should know that the CODENUMBER could not be added to Smith any more.

So we have to give a warning

Oooo...I am sorry PRODUCTNUMBER YA not CODENUMBER

RICHARDS' vba on preventing to duplicate works very well but I have to push ESC button first to delete the record and property name of the combobox can not be changed to productcombo ( still combo21)

For a different approach, you might check out Prevent Duplicates.

yes mr MATT HALL ,I used mr RICHARDS' prosedure

but I want to display a report telling that the product has been done all or still can be added

Thanks
I used RICHARDS' procedure...
Dim c as long...etc , it works
Thank you for the attention

But I use a button to open a report to see wheter I CAN STILL ADD A RECORD OR NOT

If you add a record to your form and then you have a button on that form that opens the record, and you're still not seeing the new record. That means you have to refresh or save the data in the form before you open the report. You can do it with either a Me.Refresh or a Me.Dirty = False command. Just put that line in the button before you open the report. I cover this in the invoicing video.

I am sorry to all LEARNING ZONE TUTORS,I have made you all HEADACHE

I want to start describing what I need to know

I have tables ... cuttingworkt-sewingworkt-productt

                      Cutid - CUTTINGCODE - Datecut - cutqty - productid (foreignkey) - workerid  
                                 cuttingcode denotes who cuts in a certain day (SB010925HS =SB in 01-09-2025 cut by HS-the cutworker  ....sb stands for single bedsheet)
                      
                      sewid - sewdate - sewqty - productid(foreignkey) - workerid

                       productid - sewingcost

in the SEWINGWORK FORM
      Sewid - datesewed - sewqty -  cuttingwork (relational combo) - sewworkerid

in this relationalcombo ,I want the CUTTINGCODE prevent to duplicate
IF THE CUTTINGCODE HAS BEEN USED TO SALLY , IT CAN NOT BE USED TWICE (to another sewworker)

I used RICHARDS' procedure dim c as long...etc but THE WARNING always COMES UP wheter the CUTTINGCODE duplicate or NOT.

I wonder why ...thanks

You're using the wrong event.

Before Update

Remember to name your controls. Combo21 is NOT very descriptive.

I used before update event,there still came up the warning wheter the CUTTING CODE duplicate or NOT

the relational combo is composed of CUTTINGWORT and PRODUCTT ,hence

         CUTID-CUTTINGCODE-PRODUCTNAME-CUTTINGQTY-SEWINGCOST (in format property CUTID is ZERO ;CUTTINGQTY is to show in the report wheter the CUTTINGCODE can still be ADDED to another SEWER or NOT;SEWINGCOST is to determine when the FARES CHANGE)

I really hope that you can help me

I am sorry...

is it okay to prevent duplicating on COMBO BOX of a FORM in ms access
I mean can we do it
THANKS

ALSO I want to find a record on my form based on 2 combo boxes

My form composed of 2 RELATIONAL COMBOBOXES
                                 Customercode (from CUSTOMERT : Customerid (autonumber) - Customercode (shortext) - ...etc)
                                  Productcode {from PRODUCTT : Productid(autonumber - Productcode (shorttext) - ...etc        
                          and
                                     Unitprice                  

I want to know the price of a PRODUCT of a CUSTOMER

How to solve this
thank you
              

the tables are

CUSTOMERT :Customerid (autonumber) -Customercode (short text) - Customername (short text)...etc
PRODUCTT :Productid(autonumber) - Productcode(short text) - Productname (shrt text) ...etc

CUSTPRIORPRICET :Custpriorpriceid(autonumber) - Custcode (hide Custid) - productcode ( hide productid) - Unitprice (I USED THIS TABLE for the FORM)