type in the value in the textbox(Primary key)
and then control the result from other textbox

I am not sure what you want to do here. Do you want to enter a known primary key into the text box? If so, use a combo box so the user can't mis-type the PK and get an error.

What actions do you want to take based on this entry? What is the second text box for? Do you want the results of some action to be displayed in the second text box?



mmcdonal

i just want to create a form to locate a record for updating the data by writing VBA

http://www.functionx.com/vbaccess/ho...caterecord.htm

how can i do this of it
i follow all the instrustions , but i can't make this work