goto another field if data in next field

[hullstorage]

i have a form based on a query which finds results from a postcode
so when i enter a postcode it will give reults for street, town and county

what i want to do is goto field street if no results found
and if results found goto to contact field

so basically on exit of postcode field if street is null goto street
if not null then goto contact

these are my fields in order

postcode
consignee
street
town
county
contact

 

[namliam]

Use the "On lost focus" event to "set focus" to the next disired control.

 

[hullstorage]

sorry dont quite follow
i am new to set focus

 

[hullstorage]

can you explain a little please as i am fairly new to this
tried before an even if there is or isnt any data goes straight to contact like a tab stop

 

[namliam]

If you create a "on lost focus" event and then use the SetFocus property of a text box, the Focus WILL shift to that textbox!

ControleName.SetFocus

 

[hullstorage]

sorry about private message
set focus doesnt seem to do what i need
when i enter a postcode and the results exist then i want to goto another field
if there are no result then i want to just carry on with tab order

 

[namliam]

What is wrong with the setfocus tho??? SetFocus will let you skip controls in the tab-order.

Just add a If ThisField = "" or Isnull(Thisfield) then....

???

Why doesnt it do what you want?