Need to update one field when another is chosen

[Guest]

What i am needing is for a field to be automaticly filled in when i make a
selection in another field. Ex: i have a drop down box that i choose a
company from, when i select one i need the next field to fill in with some
info i have corresponding with that company on another table.I dont know if i
am explaining that right.

 

[Guest]

For starters, you can use the After Update event of the combo box to take
whatever action you need. At that point, the value of the combo box will be
whatever company you selected.

There is not enough detail in your question to give you any help on exactly
how to do what you want because you don't say if the other table where the
data is you want is included in the form's recordset, if your are going to
have to look it up in that table or what.

If you can provide more detail, I think you will get a better answer.

 

[Guest]

I am very new to Access (teaching myself by trial and error really) see if
this is a better explanation:

I have several tables all with diff info. The main table which is the form i
am using and needing to update, is not linked to any other tables except the
one drop down box. What i would like to do is when i choose for example City
of Dallas from the drop down box, the next field will fill in from the other
table i have that has a place for what to send to the city. so when i choose
city of dallas it automaticly shows that i need to send this specific
paperwork that i have entered on the other table. Make more sense???? i still
dont think i am explaining it right.... sorry

 

[Guest]

I think I understand your explanation. What I don't understand is how you
know which record in the table has what you want to send to Dallas?

 

[Guest]

I have a seperate form where i enter info on the city. Its like a contact
form. it list name address phone fax and what to send to them.

 

[Guest]

Sorry, Breezy, I'm still not clear. Is this a different form than the one
with what you want to send? If so, what table is it based on?

What we need to know is:
what table has the info on what to send
what table has the city info
what table do you want to put what to send in
what field do you use to join the two tables together so you know where to
get what to send.

Sorry if I am being a bit thick.

 

[Guest]

No probelm, i really appreciate your help!!

Let me try this way:
table that has the info on what to send: table called "Issued By"
table has the city info: same table called "Issued By"
table that i want to put what to send in : table called "Violations"
i dont know what field i use to join them, i figured out kinda by accident
on the drop down list to choose the city from the Issued by list (i think i
may have created a seperate table that only list the citys and another that
list the city and their info.)

 

[John Vinson]

No probelm, i really appreciate your help!!

Let me try this way:
table that has the info on what to send: table called "Issued By"
table has the city info: same table called "Issued By"
table that i want to put what to send in : table called "Violations"
i dont know what field i use to join them, i figured out kinda by accident
on the drop down list to choose the city from the Issued by list (i think i
may have created a seperate table that only list the citys and another that
list the city and their info.)

Breezy, here's an analogy which might change your thinking. Think of a
Table as a file folder in a file cabinet (the database).

Suppose you had one file folder of Documents ("Issued By"). In another
file folder, each page has the name of a City. A third file folder has
one page for each Violation.

You need to send Violations records to the right city.

Given the file cabinet, how do you do that?


John W. Vinson[MVP]

 

[Guest]

John's analogy is good. The thing you have to be able to know is which
record in the Violations table the data goes to. If, as I assume, your form
is based on the Issued By table, to put data into a record in the Violations
table, you will have to have either the Violations table open as a recordset,
or some SQL code that will update a record in the Violations table or add a
new record to it. So, we are back to the original question. How do you know
which record the data goes into?