Autofilling a field, based on other fields

[C.D]

Hello - first post woho

I'm working on an anime DB, and I don't have much experience on VBA or coding in general. I'm therefore wondering if it's possible to autofill an entity, based on two entities from two separate tables.
Let's say I have an entity from the table "Anime" and one from the table "Fansubber". The main thought is to register a downloaded episode under a given fansubber, which is further linked to an anime title.
I basically want to give the conjunction of the anime title and the fansubber a name.
For instance, I have the Anime called Naruto, downloaded from the group [AonE], thus I want the AnimeFansubberName to be "[AonE]Naruto". Is it doable?
And please download the attached example DB to get a further overview!

Any help is much appriciated!

 

[ajetrumpet]

I have the Anime called Naruto, downloaded from the group [AonE], thus I want the AnimeFansubberName to be "[AonE]Naruto". Is it doable?

YES.

The first thing that comes to mind is concatenation. This is not a VBA situation though. Used a lot in forms...

You could get to "[AonE]Naruto" by way of the "&"...

me.txtbx.controlsource = [AnimeControl] & [[AonE]Control]

 

[C.D]

Thanks alot.
I've found a way to use the [tablename] & [tablename] in queries - and it works great!