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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Form W/ Combobox, Access 2007    
 
   
wizstars
post Apr 9 2020, 05:17 PM
Post#1



Posts: 139
Joined: 27-February 07
From: State of Confusion/Insanity/Panic/Despair/Denial/Chaos


Okay, after an absence of not working with Access very much, I've gone totally stupid. I have a database with a table of ZIP codes, and the associated cities and states. I'm building a form that will use that table to fill in fields on a junction table with the clients' respective cities, states and ZIP codes. I want to use a combo-box to select the ZIP code, and then have the city and state display in text boxes, without having to physically enter them. I can't get it to work--I guess I have forgotten the syntax to put in the text box controls to get them to do that. Could I possibly tap the collective genius of UA to assist me?

The combo-box data will include the primary key from the ZIP code table (hidden), the ZIP code itself, the city (hidden), and the state(also hidden); so only the ZIP code will show, and only the primary key will store in the table for the client. I've been playing with the city/state text boxes' control sources, using things like "[cbxZIPCODES].[Column(3)]", but I don't seem to be hitting on the right syntax. Or maybe I'm doing something else wrong--IDK. Help pls!

--------------------
Binary--it's as easy as 1-10-11
Go to the top of the page
 
theDBguy
post Apr 9 2020, 06:35 PM
Post#2


UA Moderator
Posts: 78,121
Joined: 19-June 07
From: SunnySandyEggo


Hi. Try moving the closing bracket.

=[cbxZIPCODES].[Column](2)

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
wizstars
post Apr 9 2020, 06:52 PM
Post#3



Posts: 139
Joined: 27-February 07
From: State of Confusion/Insanity/Panic/Despair/Denial/Chaos


Ah! MUCHO Thanko!! thanks.gif U da MAN, DBGuy!

--------------------
Binary--it's as easy as 1-10-11
Go to the top of the page
 
theDBguy
post Apr 10 2020, 11:21 AM
Post#4


UA Moderator
Posts: 78,121
Joined: 19-June 07
From: SunnySandyEggo


Hi. Glad to hear you got it to work. Good luck with your project.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    30th May 2020 - 09:06 AM