How to add a field to a mask

[Giiuseppe Gazerro]

Friends,
how can I edit a mask adding a field I have added to a table?

Thanks for any help.

[CJ_London]

Not quite sure what you are asking, but you edit an input mask for a field in the table design or in a form control where the field is the controlsouce

[Giiuseppe Gazerro]

thanks for the answer.
i apologize if i wasn't that clear.

i'll try to rephrase the question using the concrete example.

i made a db for my records.
basically it's two tables; records and songs.
(each record - many songs)

but then I added a field to the *song table* to see if I have uploaded that song on YouTube.
(Name of the field: YouTube; yes/no).

Now, in the mask I had made to fill in data, I have the submask *songs* in which, obviously, the field *youtube* is not there.

But I don't find a command which allows me to add it in the mask structure.
There must be a way to add an additional field from a table to a mask, mustn't there?

Thanks again for any help.

[CJ_London]

by submask - do you mean subform? If so there is no command as such - you just need to modify the recordsource of your subform to include your new field and then on the ribbon, select 'Add Existing Field' and drag it to where you want it on the subform.

If your recordsource is currently just your songs table or something like 'SELECT * FROM tblSongs' then your recordsource will already include it so you just need to select 'Add Existing Field'

[Giiuseppe Gazerro]

Yes, I did as you suggested and it worked.


Thanks a lot!


In the mask structure I found >>> View >>> All Fields >>> and I added the new field.

Thanks again.