how to use queries inside form

S

Sidds

hi there,
pls help me...i want to use my query inside the form & whenever i make a macro & insert my query in it & then run the form it gives me an error mesage saying that"The object is not automated ..some shit like this". i think it means that inside forms we cannot access the objects located outside the form. please help me.

i actually want to display the data in one of the fields depending upon the value i select in the first 2 fields. eg. if i select "1" in field "number" & "XXXX" in the field"Sir name" then i want to display the corresponding name contained the 3rd field "First name". all these controls are inside the form.

pls pls pls help me..i tried using everything but it doesnt work
 
Top