Auto fill a form

[dreli_20]

OK, I've searched through these forums & I'm completely new to Access.
I've just started messing with it these past couple of days & watched youtube vid's on it .

I need a how to "step by step" on how to auto fill a form.

I have two tables:
1. customer


2. permits & fees

table 1 consists of general customer info. address, phone, email, etc
11 rows total, one PK cust id, and the rest are text data types

table 2 consists of 6 rows, PK permit #, and the rest are text data types

i've set a relationship from the customer (table1) to permit (table2) as
one to many

i've set up a query using both tables & i'm stuck with what comes next.

I want a form that will give me the option to select a customer by last name and once selected will automatically pop in the rest of the customers info.

again, i'm clueless a step by step procedure would help me out immensely!


TY

[alansidman]

Is this what you are looking to do?

http://www.datapigtechnologies.com/f...tomfilter.html

Alan

[dreli_20]

TY for the response!
This is partially what I'm looking for. The other part to the form would be data entry and would vary. So the only repetitive info would be the customer info. I"m trying to save time on having to enter customer's info. over & over again.

The simplest explanation I can think of would be a repeat customer placing orders for various items at different times. So I can bring up a form start typing the customers name & have their info. automatically pop up (as it did on your link) and have a second portion where I can enter the order manually.

I hope I'm not sounding confusing

[alansidman]

Ok. Create a combo box on your form for the name you are looking up. Then using this procedure, it will populate those fields you need to have completed.
http://www.baldyweb.com/Autofill.htm

However, if you have a customer table with all the information why do you want to repeat that information. You can retrieve it in reports and queries by joining tables. Perhaps you need to look at this white paper on setting up a data base and having your tables normalized.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[dale lutz]

I too am trying to use a combo box to select a course name and then autofill another textbox based on the selection. Baldy web is exactly what i need except that it doesn't work
the form is "secondary grade entry"
the subform is "student grades 2010-2011"
the combo box is : pace name"
the textbox i need to fill is sort id.
the sort id value is in column 6 of the combo box
"pace name" and "sort id" both exist in the underlying data base
maybe I need to understand what "me" is in baldy webs example. i assumed it is the form that the combobox and text box are located but that doesn't work either.
I have a macro that i created in a database that i set up in an earlier version of access that does exactly this very nicely in an identical setting but for a different purpose. there it fills in account information based on the account number i pick.
that will not work in in this db after substituting the new names in the appropriate places. I have worked on this for 3 days now.

[alansidman]

dale_lutz
Suggest you post a copy of your db. If you are using 2010 or 2007 convert it to an earlier version before posting and do a compact and repair. Remove all confidential data and replace with dummy data.

[dale lutz]

dale_lutz
Suggest you post a copy of your db. If you are using 2010 or 2007 convert it to an earlier version before posting and do a compact and repair. Remove all confidential data and replace with dummy data.

the db is in two parts. one is the data and the other is the forms and data entry. I cannot get it today but i will shortly.

[dale lutz]

sorry, How do i attach a db?

[dreli_20]

forgive my ignorance!
the end result of this example is what i'm looking for
http://www.ms-access2010.com/tutorials/forms2.html

i'm almost there, however i get an error when it comes to the subform.

here's the info:

my customers table has 11 rows; such as last name, first name, phone#, etc

my permits table has 14 rows;

the data type i used are only text, date/time, & currency & one yes/no

i created a query from each table with all the fields for each one
i created a relationship from my table (one side) to my permit table (many side)

i went to form wizard, created a form using both queries in a subform format

when i go to open my form for data entry i get this error:
"This expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"

I have no idea what this means? i've deleted my tables & started from scratch & keep getting the same thing?

[dreli_20]

question, what would you suggest as a relationship? i think that may be where the problem comes from?

[alansidman]

i went to form wizard, created a form using both queries in a subform format

I don't know what this means. Did you try to create one form from two queries? Can't do that. A form can only be bound to one form or subform. If you have more than one record source, then you must make more forms.

Here is a tutorial on how to create a subform and place it on a form. I'm really shooting in the dark here as I don't understand what your issue is. It seems to have changed from the original posting.

http://www.datapigtechnologies.com/f...subforms1.html

Alan

[dale lutz]

here is the file i think. let me know how it works.