Auto Fill?

[Guest]

I have a form with a subform that is based off two differnet tables.
What my problem is in the sub form I would like for the user to enter the
Key # and it auto fill the other 4 fields based on the Key# that was entered,
it would pull this data from tblKeydata.

 

[OldPro]

I have a form with a subform that is based off two differnet tables.
What my problem is in the sub form I would like for the user to enter the
Key # and it auto fill the other 4 fields based on the Key# that was entered,
it would pull this data from tblKeydata.

This is tricky. It would probably be easier to do using VBA than
traditional Access commands. You could try adding code to the
AfterUpdate event that would make a clone of the recordset and add the
information to the appropriate record in the recordsetclone.