Autofill Forms

[Guest]

I have two tables EmployeeDetails and VehicleDetails. I also have a form
based on a simple query which is a combination of both the tables. On my form
[feilds in the VehicleDetails is in a subform] when i enter registration no
of the vehicle i want all other details related to that purticular
registration to appear automatically.could any of you please help me on
this??
Thanks in advance

 

[Guest]

Hi

If you form is based on the query and all the fields are in the query all
the control on the form will "fill in" when you go to the reocrd

Sear this forum (forms) for
Searching for records

and have a look at Allen Brown's answer

 

[Guest]

hi Wayne,

thanks for your reply. this one is updating the whole form - what i want is
just the Vehicle details sub form to be auto filled. also i've heard without
writing any code you can do this.. please give me some more help on this...
is there anything which i should look into the relationship of these tables?
- please help
regards

Hi

If you form is based on the query and all the fields are in the query all
the control on the form will "fill in" when you go to the reocrd

Sear this forum (forms) for
Searching for records

and have a look at Allen Brown's answer


--
Wayne
Manchester, England.

I have two tables EmployeeDetails and VehicleDetails. I also have a form
based on a simple query which is a combination of both the tables. On my form
[feilds in the VehicleDetails is in a subform] when i enter registration no
of the vehicle i want all other details related to that purticular
registration to appear automatically.could any of you please help me on
this??
Thanks in advance