Form Data to Bound Table

J

JLS04

I have a form bound to a table where data is entered by a user is saved. I
have some text boxes in my form tagged to the table by identifying the column
name of the bound table in the control source (data stores just fine). I
have some other fields where I have a formula in the control source, but
still want this data saved to the table (I need to keep an historical
record). Is there a way to tag the control source line with the name of the
column in the bound table and maintain the functionality of the formula? For
instance, I thought I could do something like this -> LineOfBusiness:
=DLookUp("[LineOfBus]","[LineDetail]","[Item] = '" & [Combo2] & "'") - where
"LineOfBusiness" is the name of the column in the bound table and the formula
says return "LineofBus" in table "LineDetail" based on "Item" and Item is
identified by the user in "Combo2." The formula itself works and returns the
data I'm looking for. The problem is, when I try to add a reference to the
bound table and column, the formula no longer works. It's driving me
crazy... can anyone help?!?
 
Top