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

(1) Share

Report

Posted on by Rafia_Mohammed

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.

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 237,978 Most Valuable Professional on at

Like (0)

Report

"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.

Was this reply helpful? Yes No
Rafia_Mohammed 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No