Recent content by hoohal

It did not work. I found a code for beforeupdate suggested by one of this forum member CEH as shown below. However, the problem with this code that we cannot use the same materialcode for different JobNo (primary key).In the other words, the code used in beforeupdate event consider the...

Yes. It did works. I really appreciate your help. This feature is new to me. how could two fields could work as primary key. can be utilized for any case ? Thank you again

How could I do such feature?

Hi all, I am beginner to ms access. I made a very simple form in ms access. The purpose of the form is to show the material list of each Job. The idea of the subform below is to select the materialcode from the droplist and the remaining filed (such as materialdescription and Unit) would be...