I've been using DLookUp in controls on forms, for instance, the control source would be:
=DLookUp("[BookPrice]","[BookBeltInfo]","[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]")
I'd like to put some sort of direct SQL statement into the control source so that the displayed value is directly editable. I.e., the user can type in the control to directly change the value in the proper field. As it now stands, the user is told, "Control can't be edited; it's bound to the expression..." How can I get something like:
SELECT [BookBeltInfo].[BookPrice]
FROM [BookBeltInfo]
WHERE [BookBeltInfo].[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]
to display directly so that the user can edit the field through the control in the form?
=DLookUp("[BookPrice]","[BookBeltInfo]","[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]")
I'd like to put some sort of direct SQL statement into the control source so that the displayed value is directly editable. I.e., the user can type in the control to directly change the value in the proper field. As it now stands, the user is told, "Control can't be edited; it's bound to the expression..." How can I get something like:
SELECT [BookBeltInfo].[BookPrice]
FROM [BookBeltInfo]
WHERE [BookBeltInfo].[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]
to display directly so that the user can edit the field through the control in the form?
