Hi, I have a table which contains 2 fields, Initials and Full Name.

On my input form I have 2 fields, Initials and Full Name.

I want users to be able to select Initials only and access to populate
the Full Name field automatically on my form.

Thanks

On Thu, 22 Jan 2009 02:47:31 -0800, Paul wrote:

Is your form entering data into the same table or into a different
table? If the former, why are you storing the same person again if they
are already in there? If the latter why copy both fields to the new
table? In that scenario you should be copying only the Primary Key value
from the first table and then using lookup mechanisms to *display* other
data about the person on your form without copying it. Is that what you
are trying to do?

If so, the more common methods are to use Dlookup(), a query for your
form that joins to the other table (this can affect edit-ability of your
form), ComboBoxes with hidden extra columns from which you can pull the
other data and display it in TextBoxes, or subforms.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Jan 22, 12:19*pm, Rick Brandt <rickbran... (AT) hotmail (DOT) com> wrote:
HI Rick, I am only going to store the Initials in the new table
butwould like to display the full name on the form when a user picks
theInitials. I have tried the Dllookup but can not get it to work.
Thanks

Paul wrote:

Have you considered a combo box? Using a query you can select the two
tables and link on the init. With it, you could create a multi-column
list. Let's say the first column is the initials and second is the the
name. Then you could put, in the AfterUpdate event, something like
Me.FullName = Me.Combobox.Column(1)
You'd use (1) as it's the second element in the column array.

On Thu, 22 Jan 2009 13:09:12 -0800, Paul wrote:

Post the expression for DLookup you used. Should be something like..


=DLookup("FullName", "TableName", "Initials = [InitialsControl]")




--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Jan 23, 12:36*am, Rick Brandt <rickbran... (AT) hotmail (DOT) com> wrote:
Hi this is what I used

Private Sub Name1_AfterUpdate()
=DLookup("Name", "tblnames", "Initials = [Initials1]")
End Sub

On Jan 23, 10:31*am, Paul <burnsp... (AT) hotmail (DOT) co.uk> wrote:
If Initials1 is text then you might need tic marks around it,
I think Dlookup needs to know it's a text value so,

DLookup("Name", "tblnames", "Initials = '" & [Initials1] & "'")

that's a single tic, double tic after the = and
a double tic, single tic, double tic after the [Initials] &
bobh.

On Fri, 23 Jan 2009 07:31:03 -0800, Paul wrote:


This does not need to be done in code (and if done in code you do not use
an equals sign at the beginning). Just put it as an expression in the
ControlSource property of the TextBox (where you DO need =).

Also "Name" is a reserved word so that might be causing a problem.
Switch to "FullName" or something else as appropriate.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com