Auto filling Form AfterUpdate question

  • Thread starter Thread starter zlehmann
  • Start date Start date
Z

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!
 
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.
 
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?
 
Back
Top