473,326 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

drop-down box - selection determines content of adjoining field

6
MS Access 2003/Win XP. I have a small table of legal entities and tax ID numbers. This table is a source for a larger tax registration table. On the larger table, the legal entity is selected from a drop-down list of legal entities (on the small table). The corresponding tax ID number never changes, so I want the tax ID field in the larger table to populate based on the legal entity that is selected. How do I enable one drop-down list to determine the contents of more than one field where both the source table and the destination table both use the same two fields?

Side note: legal entity names and tax ID numbers are such that they should be keyed as few times as possible to avoid typos, and so where both are used, the selection of one should invoke the other. That is the objective.
Jul 30 '07 #1
1 2478
ADezii
8,834 Expert 8TB
MS Access 2003/Win XP. I have a small table of legal entities and tax ID numbers. This table is a source for a larger tax registration table. On the larger table, the legal entity is selected from a drop-down list of legal entities (on the small table). The corresponding tax ID number never changes, so I want the tax ID field in the larger table to populate based on the legal entity that is selected. How do I enable one drop-down list to determine the contents of more than one field where both the source table and the destination table both use the same two fields?

Side note: legal entity names and tax ID numbers are such that they should be keyed as few times as possible to avoid typos, and so where both are used, the selection of one should invoke the other. That is the objective.
How do I enable one drop-down list to determine the contents of more than one field where both the source table and the destination table both use the same two fields?
By referencing the Column Property of the Combo Box. Assuming a 2 Column Combo Box with the 1st Column = Entity and the 2nd Column = TaxID, to write these values to Text Fields corresponding to the selected item:
Expand|Select|Wrap|Line Numbers
  1. 'Indexes are 0 based
  2. Me![txtEntity] = Me![cboComboBoxName].Column(0)
  3. Me![txtTaxID] = Me![cboComboBoxName].Column(1)
Aug 7 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Sabrina | last post by:
Hi everybody, I need some help in SQL Server. I am looking for a command that will "Drop all user table" in a user database. Can anyone help me? Thank you very much Sabrina
2
by: James Knowlton | last post by:
Hello, I'm just returning to MS SQL Server after two years of dealing with Sybase ASE. I need to drop a column, using the alter table command. I keep getting an error indicating that a...
2
by: Ryan | last post by:
Just a quicky about temporarary tables. If using QA, when you create a temporary table, it gets dropped if you close the query. Otherwise you need to state 'DROP TABLE myTable' so that you can...
6
by: hemant_mishal | last post by:
Hi All, I am writting a java script library which will provide inter frame drag and drop operation. The more precise will be OLE drag and drop, which means only data will be transfered from frame...
1
by: riehe | last post by:
Dear all I want to drop a node from a nodegroup. Can someone confirm if its enough to redistribute a node group with a partition map which doesn't include the node to be dropped? I can't see...
1
by: Ian Dobson | last post by:
Hi, I need to drop a schema from a database but it has 400 tables in it. Is there an easy way to do it other than drop table schema1.table1 drop table schema1.table2 etc.. to 400 and then drop...
10
by: BuddhaBuddy | last post by:
Platform is DB2/NT 7.2.9 The table was created like this: CREATE TABLE MYTEST ( MYTESTOID bigint not null primary key, FK_OTHEROID bigint not null references other, FK_ANOTHEROID bigint not...
8
by: WindAndWaves | last post by:
Hi everyone, Has anyone got any experience with drop and drag in Access? I would like to make a calendar style form where my users can drop and drag appointments.... I am using Access 2003...
14
by: deko | last post by:
Can the DROP TABLE statement be used with a select or where statement? DROP TABLE SELECT * FROM tblTablesImported WHERE Import_ID Not In (SELECT FROM tblTablesInternal); Or do I have to...
15
by: uwcssa | last post by:
I try to drop a table as: I got: During SQL processing it returned: SQL0478N The object type "TABLE" cannot be dropped because there is an object "sch.SQL070515104729271", of type "FUNCTION",...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.