Autofill

[Jpxfit]

Hi! I'm new to this forum stuff. I am hoping someone can provide some insight on this. Please o please.
I created 2 Tables

Table: 1 (Injury)

ID column
Department Name Column
Date of Last injury Column
Today's Date Column
Days Since last injury (Calculated Column) ([Today's Date]- [Date of last injury]= # of days that have elapsed since last employee injury)

Table: 2 (Department IQM-UM)

ID Column
Today's Date Column
Concerns
Resolution


Days Since last Injury

Essentially- I want table 2 IQM-UM), table 2(Days Since last injury) to automatically be filled with the data from Table 1 (Days since last injury).

The information I find via google, youtube is "lookup" and this gives me a drop down option which I do not want. I want every new record that happens daily to have this data field pull from table 1 automatically whenever a new record is created.

[pbaldy]

See if this helps:

BaldyWeb - Autofill

[Jpxfit]

Hi!

I appreciate the quick reply. Unfortunately this doesn't help me, while I am grateful and appreciate the information, I am trying to veer away from combo boxes and have a dedicated field either on a table or form to automatically populate informtion from another table.

[pbaldy]

Not sure why you'd want to avoid a combo, but you can use a DLookup() or open a recordset using the intput value as a criteria.

[cbende2]

Would an append Query suit your need? Just throw a button on a form to run the append query where [table1].[todaysdate]=[table2].[todaysdate] ?