Enter Info in one frame and have other frames reflect info

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

Guest

This should be easy for someone. I simply want to be able to enter info (say
a customer #) in one frame and have 2 other frames that show a city and state
 
Hi Jonathan,

assuming that city and state is stored with your customer #
in a table (I have called Tablename), you can do this:

combobox:

Name --> CustNum
ControlSource --> CustNum
RowSource -->
SELECT CustNum, Customer, City, State
FROM Tablename
ORDER BY Customer

ColumnCount --> 4
ColumnWidhts --> 0;2;1;1
Listwidth --> 4

once you pick a customer, you can echo values from the other
columns in calculated controls

textboxes:

Name --> City
ControlSource --> =CustNum.Column(2)

Name --> State
ControlSource --> =CustNum.Column(3)

column indexes start with 0 so column 2 is really the third
column of your combo

you will have to substitute the appropriate fieldnames where
I have used CustNum, Customer, City, and State

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Back
Top