Auto filling Form AfterUpdate question

[zlehmann]

I have a database for a reference in my office's library. It has a
table with the following fields:

Title: title of the book
FirstName: of author
LastName: of author
PID: Letter code pertaining to subject matter (i.e. W for wildlife)
BID: autonumber key for database
AuthorID: Initials of the author which is what im trying to autofill
in my form

ok so my problem is I want someone to be able to enter the first name
and last name in the form and have the AuthorID automatically put the
initials in.

Can anyone help me? I have some very limited VBA experience and would
really appreciate any help you experts can offer!

 

[roger]

This will give you the first letter from each field.

Me.AuthorID= Left(me.FirstName,1) & Left (me.lastname,1)

but initals won't be anything like unigue, so its a lousy ID code.

 

[zlehmann]

yeah i understand that, the author ID isnt being used to catalog the
authors in anyway, its just a step that needs to be taken when making
the ID tag for the book. thanks for the help. How would I get this to
show up in a certain field on the form?

 

[roger]

it should just show up in the AuthorID field