form to append a record in another table

[DonMcCoy]

Hi

My Scenario is:

I have two Forms:

first one is Haupttor Eintritt

the main function of this form that when you search a "Reg No" in the Search Field it finds it record from a "Bewohnerliste" Table and fill "Haupttor Eintritt" With Now Date (Just Check In Form).

second Form is Haupttor Ausgang

The same Function of the first Form except it fills "Haupttor Ausgang" with Now() (Just Check Out Form).


Both Forms are Bounded to "Bewohnerliste" Table.

both forms now are overwriting the "Haupttor Eintritt" and "Haupttor Ausgang" for each Record (Reg No) with latest Now().

My Problem is This:

I want also to add records to another table from those 2 forms.
a table is Called "Check In&Out (Omar)"

when someone search for a record from the Eintritt Form the form will append a record to "Check In&Out (Omar)" Table filling Reg No(The record that being searched in the form) field and ticking Yes in "Eintritt" and setting "Haupttor Eintritt" field for Now().


I tried a lot of codes in After Event of "Search Field" but couldn't reach other table from a bounded Form.

How could i Achieve This.?

any hint would be highly Appreciated.

[DonMcCoy]

Update:

I solved This by adding a subform (its source is the table that i want to append records in) to each of the 2 forms. and hide those subforms.
then added an after update event to the "search field" control on the main Form to tick the "Entritt" in the subform.

Forms![Haupttor Eintritt]![CheckInOutsub].Form!Eintritt = True

when ticking is happend a new record is added.