Recent content by Jon123

Got it, Thank you for the help Me.[part1history] = (DLookup("[Part History]", "Tble-Qtz Kits All Parts", "[Serial Number] = '" & Me![Part1c] & "'"))

so I moved this code to the on open event of the form Me.[part1history] = DLookup("[Tble-Qtz Kits All parts]", "[Part history]", "[Serial Number] = '" & Me.[Part1c] & "'") When the form open I'm getting an error that access cant find input table or Query Part history ???

that would be the [serial number] on the form

I am trying to update just 1 field on a form. I has a temp table and I just want to display the history based off what serial number is selected. Iwas trying to put this code in the control source for that field. =DLookup("[temptablekitmove]", "[Parthistory]", "[Serial Number] = [part1c]")

Yes you did, sorry. I got it working I had to pull it from the table then put it together and put it back. Works well. Thank you for the help today.

no matter what I try it just replaces what was already in the field. I cant get it to add to. Still trying

YeS that works AWESOME thank you. Last question I promise. When I do the Update can I add this to the already (if there is already a comment there) rather than over writing the comment that is there? Just separate them with a comma? jon

Could you explain a bit more?

is there a way to add to fields together and then add it to a field in a table. example. If I have a date field and a comment field on a form can I combine them to 1 field? Date field is 9/24/17 and the comment is "Part returned from repair" So I want this to be added to the table field History...

found it. I had a typo in my code. It works now. However, after I make the changes and update the record and then try to close the form is gives me a error that the record can not be saved because it would create a duplicate value in the primary key? Why? better yet how do I stop that from...

yes I have moved control. It is a check box If I check that box I want it to update to the table same as if It was checked and I unchecked it

UPDATE [Tble-Qtz Kits All parts] SET [Tble-Qtz Kits All parts].[Part AvailToUse] = [Forms]![Frm-updating damaged Qtz]![PartAvail], [Tble-Qtz Kits All parts].History = [Forms]![Frm-updating damaged Qtz]![comment] WHERE ((([Tble-Qtz Kits All parts].[Part ID])=[Forms]![Frm-updating damaged...

yes, the text box field updates but the Yes/No field does not???

so something like this ? [Forms]![Frm-updating damaged Qtz]![PartAvail] ???

So on the update query grid what do I put in the "update to" part of the field? If there is a check in the box for that field?