Autofill Forms

[sham_on_air]

Hi
i'm trying to make vehicle database.the purpose is to keep track of the
vehicles which is used by different departments.
i have two tables, customer [ Id(pk),Name,Title,Dept..etc] and vehicle
[ regno,make,model,color...etc and id from customer table for linking (one to
many relationhsip) ].
i've also made query combining both the tables and based on that query i've
made a form.

on the form, fields from vehicle table is attached as a subform.i want to
autofill vehicle details if the vehcle is already entered.

please help me to do this..

regards

 

[Rick Brandt]

Hi
i'm trying to make vehicle database.the purpose is to keep track of the
vehicles which is used by different departments.
i have two tables, customer [ Id(pk),Name,Title,Dept..etc] and vehicle
[ regno,make,model,color...etc and id from customer table for linking (one to
many relationhsip) ].
i've also made query combining both the tables and based on that query i've
made a form.

on the form, fields from vehicle table is attached as a subform.i want to
autofill vehicle details if the vehcle is already entered.

please help me to do this..

If you are using a subform then your main form does not need nor should it
include the vehicle table in its query. Just use the customer table for the
main form and the vehicle table for the subform. Then the Masterlink and
ChildLink properties of the subform control will take care of linking and
filtering the data in the subform automatically.