Thank you Moke123. You and Bob are life savers. However, I do have just one question. I noticed you are searching by name. How can we change that to searching by account number.
I know that some of the criteria in the query does not return any results. I did that on purpose so that I could test the update function.
In the attached db, all I have done is create a form called frmCus in an attempt to illustrate the point that I was trying to make to you in an earlier post that I made. That point is, that you don't necessarily need a different form for each action (browse, add, edit) that you may want to do with the data in a table. Neither do you want to present that data in an open query. Select queries should be used to retrieve data. Forms and Reports should be used to present that data.
So, one form called frmCus. It opens at a new record. Use the navigation arrows at the bottom of the form to browse existing records. Use a combo box in the Header section to find a specific record. This one uses the A/c Number but it could be set up to search for any field of data in the table. If you wanted to complicate it a little you could even have a second combo in the header to choose what data you want to search for (First Name, Last Name, Ac Num etc) and then change the list that's shown in the second combo to those values.
In any case, IMHO there are bigger issues that I would implore you to address before going any further with the development of your db.
Read a little about db design, normalisation and naming conventions.
Then create your tables and relationships.
Forms and Reports should be amongst the last things required.
