Recent content by GeoffO

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

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

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

Hi How do you do that Alan? Thanks

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...

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