Looking for an editable varient of DLookUp

Banaticus

Registered User.
Local time
Yesterday, 20:24
Joined
Jan 23, 2006
Messages
153
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?
 

Users who are viewing this thread

Back
Top Bottom