Recent content by melrios98

Thank for your response. I'm using a query with the combo box of the equipments. I can't write any other than equipment on that list.

QUERY EquipmentID --- MoldID --- Task 1 4 Clean 4 3 Change 5 2 Out I need to filter the equipments, sometime 1 of them and sometime all. I have a table with a combo box that list all my equipments and this combo is the criteria on the EquipmentID field of the QUERY. My...

Thanks Neil for your fast responce I try to create a Set Value Macro on the Before Update Event but not work for me. Can you help me?? That is what i do Item: [Forms]![PO]![Transacction subform].[Form]![Line] Expression: DMax("[PONo]","[PO]","[Line]= ")=[Line]+1 Please give me an idea

I'm new in access and have a question here for all of the experts. I read some other post on this issue but not found a good example that work for me. Here is my request. I have 2 tables Table : PO PONo - AutoNumber Date - Text Name - Text Table:Transactions PONo - Number Line - Number Item -...