Dlookup Checkbox syntax - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dlookup Checkbox syntax

Teeka Leone

5 years ago

I haven't found an example ANYWHERE of how to get the value of a checkbox using Dlookup so wondering if it's not supported in Access? The control on the form is a checkbox which matches the datatype on the table I'm looking it up from. On the properties of that checkbox on my form I have: =DLookUp("SSOchk","EnvironmentsT","EnvID =" & [Forms]![DeploymentsF]![EnvID]) I have the code in the default value property of the control because this is a bound field. I have the control name in the control source property as I need it to get the value from the environments table via DLookup, but then write that value to the deploymentsT. If there's a better way of doing this, I'm all ears!

	Teeka Leone OP @Reply 5 years ago
Never mind. I think my testing was faulty. DLookup doesn't seem to work when the field is bound. The code only works when the form control is unbound and the DLookup Code is in the control source property. Correct?

	Richard Rost @Reply 5 years ago
Nope... actually it's the other way around. DLookup looks up a value FROM A TABLE OR QUERY, so the field NEEDS to be bound. You can't DLookup an UNBOUND field on a form. But you wouldn't need to. You'd just say =Forms!FormName!Field

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View