Hi
i have 2 querrys with the same fields but different criteria (one is to search a person throw their id and the other one to search a person by their surname and dob). i can't work out how to display the results of the querries to an existing form i have. Can anyone help me please?

What you need to do is, on some form event, programmatically change the form's rowsource to which query is needed, e.g.


private sub OnEventOfYourChoice()
if (whatever) then
me.rowsource = "Query1"
else
me.rowsource = "Query2"
end if
me.requery
end sub