Automatic Field DAta Entry

[Lupson2011]

Hi, I have a table with the field names Trust1 (which is a 5 digit code) and Trust3 which is the name of the organisation. There is a code for every corresponding org name.on a form, I have a combo box which you can choose the org name (Trust3). I also have a text box with Trust1 (5 digit code) as the control source.What I want to do is when I have chosen the org name (trust 3), the corresponding code (trust1) appears in the text box for that org name automatically. Does anyone have the handy code for this small procedure?thankslupson2011

[LillMcGill]

I don't understand what you're doing... it sounds like you're storing both the Org name and the Org code in a related table, so I must be misunderstanding.

[Lupson2011]

The org name and org code are already in a table. What I want to do is when you choose the org name from a combo box, I also want the corresponding org code to display in the text.So basically, its is saying, 'ok you have chosen 'Avon', here is its corresponding org code. AVON1 (displayed in the text box)Am sure it is something that goes behind the text box or the combo box?Hope thats a little clearer?Lupson2011

[rpeare]

I'm assuming the Trust1 field is a unique key, in other words it can't (and isn't) duplicated anywhere in your table?

If so make you combo box have two fields, the first being TRUST1 (the bound column) and the second column be Trust3. Set the column count to 2, set the column width line to 0;2.

Make the field where you want the trust1 information to appear an unbound text box set the control source to =[comboboxname] where comboboxname is the acutal name of the combo box on your form.

[LillMcGill]

Your post title says "Automatic Field data Entry", so I was concerned that you were trying to do automatic field data entry.

Here is a sample, where the combo box has 3 columns, but the column widths are 1.5;1.5;0
cboStatusId Row Source:

SELECT [tblStatus].[StatusID], [tblStatus].[StatusCode], [tblStatus].[StatusName] 
FROM tblStatus 
ORDER BY [StatusCode];

And to DISPLAY the Statusname in a textbox, set the textbox Control Source:

=cboStatusId.column(2)