Autofill Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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

Wayne-I-M said:
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.



Sham_on_air said:
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
Click to expand...
Click to expand...
 
Back
Top