UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> I want to lift 2 or more fields at the same time from a base tab    
 
   
ekemini
post Oct 19 2008, 10:25 PM
Post #1

UtterAccess Member
Posts: 20



i want a drop down list in the Zip Code field in the Secondary tbl so that once i pick a value from this Zip Code drop down list (these will be the Zip Code values in the base tbl), the corresponding values of the State and Country from the base tbl will appear at the same time in the secondary tbl.
Go to the top of the page
 
+
Peter46
post Oct 20 2008, 03:17 AM
Post #2

UtterAccess VIP
Posts: 7,394
From: Oadby Leics, UK



Can't be done in a table.

You have to use a form and also add some code to the afterupdate event procedure of the combobox used to select the zip code.
It woud be something like..(assuming zipcode is the first column in the combo box)

me.txtState = me.comboname.column(1)
me.txtCountry = me.combobane.column(2)
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 09:25 AM