Invald or Primary Key Cannot contain a null value

[Alex]

Can anyone tell me why I might be getting this message when I add the
following code in the AfterUpdate event of one of my 3 primary key fields in
my table called NewParts, which has a left join to the below table
ExcelBRefParts in my query, which is the data source for my form. When I
click Close, I get the message, but all three primary key fields are
complete. Any ideas? Thanks much.

Me.Act_New_Part_Var_Cost = DLookup("[Variable]", "ExcelBRefParts", "[PART#]
= [New Part#] And [AS PART#] = [New Part NHL] And [Model#] = [Model]")

 

[Barry Gilbert]

If you have it working for dates, the only difference is to get your code to
see only the time portion of the control's value. Try using the TimeValue()
function.

Barry

 

[Alex]

Dates? There are no date fields in my form.

If you have it working for dates, the only difference is to get your code to
see only the time portion of the control's value. Try using the TimeValue()
function.

Barry

Can anyone tell me why I might be getting this message when I add the
following code in the AfterUpdate event of one of my 3 primary key fields in
my table called NewParts, which has a left join to the below table
ExcelBRefParts in my query, which is the data source for my form. When I
click Close, I get the message, but all three primary key fields are
complete. Any ideas? Thanks much.

Me.Act_New_Part_Var_Cost = DLookup("[Variable]", "ExcelBRefParts", "[PART#]
= [New Part#] And [AS PART#] = [New Part NHL] And [Model#] = [Model]")

 

[Barry Gilbert]

Sorry. Somehow my response to another posting made it to this one.
Multi-tasking seems to be my downfall today.

Barry

Dates? There are no date fields in my form.

If you have it working for dates, the only difference is to get your code to
see only the time portion of the control's value. Try using the TimeValue()
function.

Barry

Can anyone tell me why I might be getting this message when I add the
following code in the AfterUpdate event of one of my 3 primary key fields in
my table called NewParts, which has a left join to the below table
ExcelBRefParts in my query, which is the data source for my form. When I
click Close, I get the message, but all three primary key fields are
complete. Any ideas? Thanks much.

Me.Act_New_Part_Var_Cost = DLookup("[Variable]", "ExcelBRefParts", "[PART#]
= [New Part#] And [AS PART#] = [New Part NHL] And [Model#] = [Model]")