How do I automatically get access to put two field together

[kasey217]

Here is my dilema. I have a database that has account numbers and I would like to be able to have a name assoicated with that account number so when I key it into the transactions the account name with automatically come up. How do I do that? Thank you in advance. I am just learning Access so I am having a time...

 

[Corticus]

Re: How do I automatically get access to put two field toget

Hi Kasay,

How are you entering this data? Into a single form? Or a datasheet (a list of records)?

Either way, you will need a table that relates account names to numbers, then in a query you can look up the name based on the account number entered.

For example, say you have a single form bound to a table. Instead, create a query that has all the fields of the table, then join in the table that relates account numbers to account names and add that field to the query. Then add a control to the form that is bound to this looked up value. You could also use a 2 column combobox and make the rowsource of the combo the table that relates numbers to names. Make the column count 2, with the column widths set to 0". Have the rowsource with criteria that comes from a control you data enter on the form, and when this control is updated, requery the combo.

Hope this helps,

 

[kasey217]

Re: How do I automatically get access to put two field toget

What I want to do is get an account number to automatically fill in linking to the account type. So when I enter the account type in it will fill in the account number. I am in a table.

It is a single table. There are 4 tables all together.

 

[Andrew Fergus]

Re: How do I automatically get access to put two field toget

Following on from Corticus' post, you might want to have a look at using a form to enter your data - there are some good articles on using forms on the MS website here and here

HTH, Andrew.

 

[kasey217]

Re: How do I automatically get access to put two field toget

Thank you,
I am using forms but it still makes me put the account number and account type in. I don't know what I am doing wrong. Thanks for all your help too.

 

[Corticus]

Re: How do I automatically get access to put two field toget

Somehow, you're going to have to use a query to look up the account name based on the number you enter. To do this, you could either bind a form to a query with a criteria set to the account number entered, or through a control, such as a combo that employs an SQL expression as it's rowsource. You could also you ADO to run a dynamic query in your code, using the textbox that receives the account number as your criteria, and then return whatever the query returns to a control of your choice on your form.