I have an MS access 2007 form. A textbox Field1, combo box Field2 and another textBox Field3.

When data is entered in field1 and a entry is selected in field2 and when clicked on field3, data must be populated by looking up the record entry present in the table (which contains field1, field2, field3).

For this, i would like to add VBA code for field3_OnClick routine. I think we need to add an SQL query inside the routine to do this. But i dont know how to write this. Can any one of you guide me on doing this. Thanks.