News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Need a query range to ...

Finance | Project Operations, Human Resources, ...

Unanswered

Need a query range to hide or lock the lookup field and also Need active date

(1) Share

Report

Report

Posted on by Rafia_Mohammed

2

Hello everyone, I need only a query range to give End date should be active and also i need to hide one look up field value which is highlighted below.
Attaching the images for reference.

All responses Img

All responses (2)

Answers Img

Answers (0)

Rafia_Mohammed 2 on at

Like (0)

Report

Need a query range to hide or lock the lookup field and also Need active date

I got you, but i have to create a query and create a menu item, give the object as the form and query as , the query which i have created. user need separate form where he/she can able to see some filtered data, so now only option is query. please guide me what i can do. thanks.

Need for both enddate and hide/lock look up field value using query
Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

Need a query range to hide or lock the lookup field and also Need active date

"End date" that you see in the form isn't a query range. It's a form control, most likely bound to a data source field. You can change properties of the data source field (not the range!), such as Allow Edit = No.

The other requirement requires a change to the lookup query. But first, you need to think about how you identify the value to exclude.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans