Hi,
I have a form that there is a combo
box and an edit box. I have a table with Customer ID, Company Name and
Country. I want to do that when my combo box chooses an item(eg
McDonald in Company Name) in the form, the edit box can show another
item (eg USA in Country) after the trigger. How can I do that? I've
tried to do so, but the edit box still cannot show the related item,
but only blank to let me enter info.
Thx very much!
Raymond 2 2593
Make sure you combo returns the Country in a column - it can be hidden by
setting that column width to 0.
In the Control Source for the text box put -
=NameOfCombo.Co lumn(ColumnInde x)
ColumnIndex is a 0 based index. Count the column from left to right 0,1,
etc.
Jeff Pritchard
_______________ _
Asken Research Pty. Ltd.
Access Database Developers www.asken.com.au
"studentZ" <is*********@ya hoo.com.hk> wrote in message
news:3d******** *************** ***@posting.goo gle.com... Hi, I have a form that there is a combo box and an edit box. I have a table with Customer ID, Company Name and Country. I want to do that when my combo box chooses an item(eg McDonald in Company Name) in the form, the edit box can show another item (eg USA in Country) after the trigger. How can I do that? I've tried to do so, but the edit box still cannot show the related item, but only blank to let me enter info. Thx very much! Raymond
"studentZ" <is*********@ya hoo.com.hk> wrote in message
news:3d******** *************** ***@posting.goo gle.com... Hi, I have a form that there is a combo box and an edit box. I have a table with Customer ID, Company Name and Country. I want to do that when my combo box chooses an item(eg McDonald in Company Name) in the form, the edit box can show another item (eg USA in Country) after the trigger. How can I do that? I've tried to do so, but the edit box still cannot show the related item, but only blank to let me enter info. Thx very much! Raymond
Please visit: http://www.mvps.org/access/
They are always looking for work.
Schill Willingly This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: studentZ |
last post by:
Hi,
I am a beginner in Access. I want to do a form that there is a combo
box and an edit box. I have a table with Customer ID, Company Name and
Country. I want to do that when my combo box chooses an item(Company
Name) in the form, the edit box can show another item (Country) after
the trigger. How can I do that?
Thx very much!
Raymond
|
by: Lucinda Roebuck |
last post by:
I'm using Access 97 on a Windows XP computer. The combo box on the
form "form1" will not refresh after a new name is added to the list.
The "limit to list" properties for the combo box is set to yes. When
I type a clients name in the box that is not in the list, the form
"Add New Client Form" opens to add the client. When I return to the
main form, the combo box will not refresh until I click on a name in
the box and then click the...
|
by: Ron L |
last post by:
I have a dataset whose source is a SQL 2k stored procedure that I am trying
to display in a datagrid. This datasource has 4 columns that I am
interested in here, a text column and 3 value columns corresponding to
permissions to certain data classes. I want to put the permission values in
combo boxes in the grid and instead of displaying the numeric values, have
the combo box display a string that corresponds to the numeric value (i.e.
No...
|
by: Duncan Barnes-Ceeney |
last post by:
I’m having problems with a custom Combo box. The main problem is that I want
to modify the look of the combo which includes the size of the button. To do
this I have inherited from the standard combo set it as a UserPaint and
provided my own paint. This along with the standard Owner Draw for the list
items works fine for the DropDownList version, the problems start with the
versions with the edit box which are where the problems are.
...
|
by: The Eclectic Electric |
last post by:
I'd be very grateful if anyone could help me with this. From my limited
knowledge of Javascript I don't think it is possible, but I'll punt anyway.
I downloaded and very slightly adapted this guy's Javascript "combo box" -
http://sandy.mcarthur.org/javascript/select/select.html. It allows my users
(when I get some!) to select from a list of preexisting options and also to
add a new one by clicking on "add new". Essentially it's a select...
| |
by: virtualgreek |
last post by:
Dear All,
First of all I would like to take the time to thank you all for your efforts and time spent at this wonderful forum. I have found it very helpful with numerous examples available for every level of user.
I am facing a rather weird behaviour with a combo box on a subform (Continuous form).
I have two tables. Order and Order_Details. The master form is based on the Orders tables and the details form (subform) is based on the...
|
by: John |
last post by:
AC2007
I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.
First column is primary key (ID). Second column is a concatenation of
two fields (Descrip & UserID).
When I start typing letters of an existing description (Descrip), the
combo does not autocomplete. If I select a choice from the combo, it
|
by: sejal17 |
last post by:
hi everyone,
I have a page with combo box.
paypal payment:<select name="paypal">
<option value="On">On</Option>
<option value="Off">Off</Option>
</select>
I want to edit the value.If i have add On then in editing i want to edit it with Off.
|
by: ddtpmyra |
last post by:
Hi,
I have PHP script that I use for new entry and edit entry, inside the form I have query combo (combo values querying from other table), my problem is how make the default value of my combo to actual value on the edit table instead on picking the first value on my query.
For instance I have query combo CAT, DOG, RABBIT.
1st time entry user choose RABBIT and then save, then user go back to edit page this time the combo will display...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |