Search results

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?

I have a form that I use to edit some information on a part. So I have a combo box that the user selects the part they want to edit. Once they have the correct part there are 3 yes/no boxes that would be updated, a Date field and a comment field. Once modified I want to run the query to update...

I'm getting a type mismatch? Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Kit TOTE Number] = " & Str(Nz(Me![totenumber], 0))

I have a form with a combobox that is linked to a box number I want to select a box value and then have that record displayed. I cant get the gotorecord on the after update working on that combobox it that the rightway to go about this?

I have been doing a ton of searching on this issue and looks like its something I should be able to do but cant. I have a table linked to a form say 10 fields. Simple enough, the table has a primary key and its an autonumberd field. I'm trying to prevent incomplete records so on the close button...

thank you that worked