Search results

Table As' value X,Y,Z can be changed from form A depending on the sure. Form B is more like a searching purpose. It takes in user's input of value X and Y, in order to search table A and displaying value Z. At the same time, table B will be keeping the records of the input X, Y and the output Z.

Table As' value X,Y,Z can be changed from form A depending on the sure. Form B is more like a searching purpose. It takes in user's input of value X and Y, in order to search table A and displaying value Z. At the same time, table B will be keeping the records of the input X, Y and the output Z.

Sorry I am not sure what you meant by Z value unchangingly dependent. But basically, table A contains X, Y, Z and all these values can be changed if Form A (linked to table A) is changed

I am kinda newb in vba. Can you please advice where do i put the codes into?

Hi guys, i got a problem here. I have two tables, table A and table B. Table A is a master table where it contains various values. I want to do it such that if user keyed in value X and value Y into Form B (linked to table B), it will check Table A for value X and value Y. If the values...