Access Tutorial - Setting the default value

preview_player
Показать описание

#Access
#HowTo
#LinkedIn
Рекомендации по теме
Комментарии
Автор

What if I have a drop down menu, and I want a related column to auto fill from a table base on the drop down option I choose?

judahparker
Автор

In this same database, let"s suppose that data to States field comes from a related States table. If we try the same expression ="CA" we got an error message. What to do in such situation? I'm trying the DLOOKUP expression = dlookup("[State]", "[States]", "[StateID]=2") but got an error message.

Esclarecidos
Автор

I have a ms access table where there is a field name "Last Date", which is a date/time field. I want to build a columnar form where the default date what is put in the design view table should appear in all Last Date fields. Is it possible?

satyabanukil
join shbcf.ru