Post Office

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

i have a table holding info on post offices and would
like to create a form so that a combo box can be used to
select them and the data altered to reflect that post
office so i can change the information if necessary. any
ideas?
 
Gareth

How is this a ".queries" newsgroup question?

Are you saying you want to create a form you can use to edit information you
have in a table? What have you already done to create/develop this form?

Good luck

Jeff Boyce
<Access MVP>
 
i have a table like this:
postofficenumber
name
streetname
streetname2
town
county
postcode
telnumber

i have a form with all fields bar the post office number
as these are not to be changed at all. i want the combo
box on the name field so that when one is selected all
other text boxs alter to reflect that post office. i was
thinking that it was the query that is used to find the
information that was wrong. its just a simple query
requesting all the information from the table, sorry if
this is the wrong place i am a complete newbie at this
 
You can use the ComboBox Wizard to create a ComboBox Control to do this. In
the first dialog window, select the 3rd option "Find a record on my form
based on the value I selected in the ComboBox".
 
Back
Top