auto populate

[omer123456]

I have a table with 3 fields

Family
Description
House #


What I want my form to do is......... When I select that family, it auto populates description and house # for me...... then save this information in another table.

Thanks in advance

 

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

 

[omer123456]

Not sure if I fully understnad, but yes, I am wanting to populate the field 2 & field 3 fields based on my selection of Field 1

Then save it to the form

 

[omer123456]

Take a look

 

[pbaldy]

To save, the textbox needs to have a control source of a field in the table. If one is working and the other not, check the column count property of the combo.

 

[Matoco1]

Take a look at this is should help you. http://youtu.be/d2PI6w_J95Y you can use the dlookup for the family and Dmax +1 for your increment, this should probably be done with an auto number though.