Auto fill on a form

[Guest]

Hello, I have a form that has a Tab Control with 8 tabs. I want to be able to
bring up some basic info like Name, Employee ID, Date of Performance
Appraisal department ect in the first tab and somehow autofill all the
information that has to do with that person for that date in the other tab
subforms. I found something here:
http://www.mvps.org/access/forms/frm0058.htm but I dont know how to
incorporate it into my DB. Please help...Thanks!

 

[John W. Vinson]

Hello, I have a form that has a Tab Control with 8 tabs. I want to be able to
bring up some basic info like Name, Employee ID, Date of Performance
Appraisal department ect in the first tab and somehow autofill all the
information that has to do with that person for that date in the other tab
subforms. I found something here:
http://www.mvps.org/access/forms/frm0058.htm but I dont know how to
incorporate it into my DB. Please help...Thanks!

First off, data is not stored in tabs nor in subforms nor in forms: it's
stored in tables, and subforms only *display* the data. If you're trying to
store data redundantly in eight different tables, *DON'T*; the employee name
should be stored in the employee table, *only*, and not stored anywhere else!
You can put a textbox showing it on the mainform so that it's visible outside
the tab control in conjunction with any subform data.


John W. Vinson [MVP]

 

[Guest]

You must have misunderstood my question. I know data isnt stored into tabs
thats common sence. I just wanted to know how I could auto fill a subform on
my form?
Thanks...

 

[John W. Vinson]

You must have misunderstood my question. I know data isnt stored into tabs
thats common sence. I just wanted to know how I could auto fill a subform on
my form?
Thanks...

What's the Recordsource of the main form? Of the subform? What value do you
want to copy from the mainform into the subform - *and why*?

John W. Vinson [MVP]

 

[Guest]

What the solution described in the link does, is to insert the data in the
list.
You state what column the data is to be taken from.
If you do not include all the columns that you need in the combo, you might
need a DLookUp instead.

You place the DLookup in the combos (or whatever fields) AfterUpdate.

Example.
DLookUp("[FirstName]","Customers","[ID] = [ID]")

Meaning something like
Look up First name from table Customers where ID is the same as in the field
ID in the form.