Search results

I think you've forgot to put quotes around location1. Since you say the value is 'tr' it must be a string and thus would need quotes around it. Try this: sqlstring = "UPDATE Location SET location1= """ & [Forms]![View die locations]![location1] & """ WHERE [PSM Code] = '" & linked & "'"

Best guess would be that your code is requerying the subform which would constantly keep reseting the forms data.

Thanks, didn't think to search for that. Hadn't thought it'd be that complicated. Anyway, I found a quick and simple workaround that works find for me since there is only 1 record. Private Sub Form_Current() Me.Recordset.Clone.MoveLast If Me.CurrentRecord >...

Hi, Just a quick question. I have a form of records, frm2, that gets opened via another form, frm1. Dependent on the content of frm1, frm2 is opened with a certain filter that shows only one record. I need to have it this way as there is too much data to show on just one form. Frm2 does filter...

Thanks EMP, that was it. It worked now. I always thought if something was autonumber you could just insert '' and it would ignore it. Apparently not. Thanks again.

Hi, I am trying to move data from one very messy database to another. I created a query in the messy database that grabbed values i'd need them imported into the new database. I now wanna transfer the values from the query to the new table I've made. I figured I would set up a loop in VBA...