use a field to autocomplete look up informatin from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need my form to auto complete a field... i want it to go this is the suburb
this is where it was deliverd from... so this must be the zone so instead of
me looking up and manually entering the zone i want it to know it all read
when i knows the other two variables...

Please can anyone help me im stuck

thanks in advance
 
It's not quite as simple as that unfourtunatly...

in my table where the information is stored i have a list of the suburbs in
the first field then there is the four quaries that we supply from. and under
those fields are the zones that they fall under... for exampl a delivery to
suburb "A" from quarry "C" is i zone 6 delivery i need my form to auto
complete this for my because its too time consuming for me to be sitting
there looking it up when access has all the data it needs i just need to
instruct it

Thanks For All Your Help
Kind Regards
AnnAKeY666
 
Back
Top