Form/Table Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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...
 
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.
 
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?
 
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.
 
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.
 
Back
Top