Search results

  1. G

    Combobox & Add record

    Hi I have a form with 5 fields on it. The primary field (ID number) is a combobox. How can I add new records through the combobox & also edit records. The form has just one Table with all the data. Thanks Geoff
  2. G

    Last record Problem

    Thanks Alan I managed to get it to work before I read your post by changing the textbox to a listbox then refreshing the form on the save record form. I will try your way as a textbox looks better than a list box. Thanks Geoff
  3. G

    Filter by form (No records Msgbox?)

    Hi Use Form.RecordsetClone.RecordCount as the query name? Thanks Geoff
  4. G

    Last record Problem

    Hi How do you do that Alan? Thanks
  5. G

    Filter by form (No records Msgbox?)

    HiI have a search form that opens with "filter by form", the problem is if no records are returned the form goes blank, how do I get it to display a msgbox?. I've seen some posts saying use "DCount" If DCount ("*","QueryName")<= 0 then MsgBox "No Records Match" Exit Sub End If But since my...
  6. G

    Last record Problem

    Hi I have a textbox on a form which displays the number of the last record entered. =Last([Table1]![ID Number]) Then problem is when I enter a new record and save it, the last record field doesn't update until I close the form and re-open it. How do I make it update automatically?. Geoff
Back
Top Bottom