Auto-population

[Ashley25]

Hello,



I'm trying to figure out a way to get my access database to auto-populate data into a field based on the information I type into the first record.

So what I'm looking to do is that when I type a name into the UserName Field it will automatically fill in the rest of the field with the same information.




To clarify I'm looking for a way so that when I type something into one record it will fill the rest of the field in with that same information.

I appreciate any help or advise you guys have to offer. Thank you for your time.

[June7]

What do you mean by 'rest of the field'? You want data to carry forward into subsequent records during data entry?

[Ashley25]

Yes. Is that possible?

[Ashley25]

I know the whole 'Ctrl' + '"' trick but i just want it to automatically fill in without having to manually go through to fill in the records

[June7]

Yes. Use VBA code to set the DefaultValue property of each control you want value to carry forward.

Review:
http://access.mvps.org/access/forms/frm0012.htm
http://allenbrowne.com/ser-24.html
http://support.microsoft.com/kb/210236

[Ashley25]

Those work great but not exactly what I was looking for. Those all seem to go if you already know the value you want to be carried through. What i'm looking for is more so if another user was filling in the information if they typed something in it would fill in the rest of the fields for them.

So what i'm looking for is a code or an expression i can apply to my database so when i type in a name it will fill in that name in other records without having to put that name into the code or expression.

Does that make sense?

[June7]

No, I do not understand. Your statements seem contradictory.

Do you want to autopopulate fields of the same record based on name entered?

Or do you want values entered in first record carried forward to subsequent new records in the same session?

[Ashley25]

I want values entered in first record carried forward to subsequent new records in the same session.

[June7]

I have provided code examples for that.

The code references the controls by name. The values in the referenced controls will be used to set the DefaultValue property.