How Do I............

[zambam]

AutoFill Form Fields??

hey, How do i create fields whereby if a members surname is typed in a form, his details such as Member ID etc. will automatically fill the fields without having to enter them?

please help this is urgent. thanks!

 

[Vbark]

Try adding a list box or combo box to the form, it must have the record source set as the one you wish to query, the wizzard pops up, you have three options choose the bottom one and see how you get on. let me know if you get stuck...

 

[Vbark]

Actually to take that one step further the next step you would select member id and surname, next yes to hide key column, next then finish.

 

[Oldsoftboss]

Thats what relationships are for. And NO it is not urgent.

 

[Oldsoftboss]

And the search function.....?

 

[Oldsoftboss]

Take any two tables related by a one-to-many relationship. Create a query that includes ONLY the related field from the "many" table and ALL of the "one" table's fields EXCEPT the related field.

Run the query, and then make a valid entry into the "many" table's related field, and the rest of the fields should fill in.

If it works... and it should... save the query, then create a form using the query plus whatever other fields you need.