Auto fill fields

[LG]

I have posted this before but, still can't seem to find the answer that
works. Maybe I am missing something.
I have 3 tables that need to feed into a form. TBL_memb, TBL_Reason, and
TBL_appeals
I already have a query that takes the reason codes into the form and prints
out the description in the report.

I now have the appeals table that has Carrier, Agency, Phone, Fax, Add2,
City2, State2 and Zip2
These fields are currently in the TBL_mbr and TBL_Appeals. (They are in the
member table since I currently copy and paste them from excel) The actual
data is stored in the TBL_Appeals

What I want to do is have the form set up where the processor enters the
carrier say 1000 and the Agency, Phone, Fax, Add2,City2, State2 and Zip2
automatically will fill the fields.( I tried the combo box but, it comes up
empty or with just the zip2) Then when I create the report and they print it
the info will print but, not store in the table.
The form that will be created into a report is 3 pages total and have the
fields below fill in
the appropriate places. Fields:
QCP_ID, Last_Name, First_Name, Address1, Address2 ,City ,State, ZipCode,
Mbr_ID,
Rcvd, Meds, Reason1, Reason2, Reason3 ,Proc, Carrier, Agency, Phone, Fax,
Add2, City2, State2, Zip2, Date
I tried to look at the examples but, could not get the combo box to create
correctly.
Many of the examples I looked out I could not put into place with all the
fields I have.
Thanks for any assistance or suggestions.

 

[Gina Whipp]

LG,

Why are you trying to store information from one table into another table?
All you really need to do is base your form/report on a query which will
display information from the tables you want to see. Perhaps your tables
are set up like your Excel spreadsheet? (BTW, that would be a no-no...
Access is not Excel on steriods!)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[LG]

I have figured it out and works now.
I used and after update event procedure.

 

[Gina Whipp]

LG,

I am glad you figures it out! However, it still sounds like your are
storing the same information in two tables which would defeat the purpose of
a well normalized database. This may cause you issues in the future. If
you are not concerned with that no problem but if you are you might want to
look into normalizing your tables.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm