Recent content by DuncanMcCloud

I figured it out. If the field is one that is updated with the code as per the single line of code (see above) for each form field, then the active field (the box where the keyboard cursor is active) cannot be one of these fields that are updated. So what i did was i changed it so that the...

here is the code for the form in question: Option Compare Database Private Sub companyname_BeforeUpdate(Cancel As Integer) Form_frmClient.companyname.Value = LTrim(IIf([LastName] = "", [firstname] & " " & [Title], [LastName] & " " & [firstname] & " " & [Title])) Form_frmClient.OrderBy...

There is a text field that gets the firstname, lastname and title appended each time the user completes a new client form. e.g. Form_frmClient.companyname.Value = LTrim(IIf([LastName] = "", [firstname] & " " & [Title], [LastName] & " " & [firstname] & " " & [Title])) This all gets saved on...

Hey Readers, I'm using MS OFFICE 2003...MS ACCESS I am having a problem in my one form where I have to click on the "go to next record arrow" twice before it displays the next record. (even on the "create new record" it requires 2 clicks) All other forms I have display the next record for...