 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2005Form/Table Question
I have a form (frmCustomer) based on a table (tblCustomer). I will use the form to add new customers to my table and a separate form to modify existing records. How can I get my form to default to the next record to add rather than displaying the first record in the table when it is first opened? thanks, Ted I don't understand the purpose of using separate forms to add or edit the same data but, you can change the Data Entry property to Yes on the form that you only want to add information with. > I have a form (frmCustomer) based on a table (tblCustomer). I will use the > form to add new customers to my table and a separate form to modify existing [quoted text clipped - 4 lines] > > Ted I understand and you are right about not using separate forms. I'm new to this and just trying to figure-out a few things. Ultimately I want to create a form that allows me to enter new customer records and edit existing ones. I'm trying to learn about combo, list and text boxes and when to use each. I want to be able to display a dropdown list of customers that the user can select to display the related info for editing and at the same time allow new customer records to be added. I can use a combo box to display the list of existing customer id's but I don't yet know how to get it to allow me to select one of the id's and then display the rest of the related customer information like street and city and so on. Any guidance is appreciated. Thanks... > I don't understand the purpose of using separate forms to add or edit the > same data but, you can change the Data Entry property to Yes on the form that [quoted text clipped - 8 lines] > > > > Ted Typically, text boxes are used for information that is non-recurring that the user inputs through the keyboard. A combo box is used when there are a limited number of responses available. The use of a combo box also ensures data integrity by virtue that the user must choose from a list of options (when "limit to list" is chosen as a property for the combo box). The list box is used when a set of choices are available also but unlike the combo box, the list box shows all choices on the form at one time. The list box also allows the user to pick multiple choices from the list. You can create a combo box that will bring up the corresponding customer record by using the wizard. Put the combo box in the form header or footer and tell the wizard that you want the function of the combo box to be to find specific records. One form will work. It will all become clear to you as you use the forms more and more. > I understand and you are right about not using separate forms. I'm new to > this and just trying to figure-out a few things. Ultimately I want to create [quoted text clipped - 26 lines] > > > > > > Ted That was very helpful. I appreciate your taking time to respond in depth. One last question, if you have the time. I have several fields on my form: cust_id, name_last, name_first, addr_strt, addr_city and so on. All of these are based on the fields in the tblcustomer table. When I select a customer id in the combo box, I want the other fields to populate with the appropriate data. How do I get that going? Do I need to base my form on a query rather than a table? > Typically, text boxes are used for information that is non-recurring that the > user inputs through the keyboard. A combo box is used when there are a [quoted text clipped - 43 lines] > > > > > > > > Ted I generally don't like to base my form on a query unless the form loads more than one table. It just leads to complications down the line. Base your form on the table itself. You can use the form wizard to help you create a form or use autoform for more of a cruise control approach. Once the form is created, use the wizard to add an unbound combo box in the form header or footer. The first screen in the wizard asks you to identify the purpose of the combo box. Choose the bottom option to "Find a record on my form...." When the user selects a customer from the combo box, the appropriate data relative to that customer will display in the form. > That was very helpful. I appreciate your taking time to respond in depth. One > last question, if you have the time. I have several fields on my form: [quoted text clipped - 53 lines] > > > > > > > > > > Ted I guess I should clarify something. When you use the wizard to create the combo box, select the customerid and the customer name. The wizard will give you the option to hide the first column (customerid) which is what you want to do. The user doesn't need to know the id to choose the correct record. I know my customers by name....well most of the time. > I generally don't like to base my form on a query unless the form loads more > than one table. It just leads to complications down the line. Base your form [quoted text clipped - 64 lines] > > > > > > > > > > > > Ted |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.