1 Table From 2 Forms

[ACCESS NEWB]

My mind just blocked and cant figure this out.Please help.
How to make 2 forms feed 1 table.
In my 1st form i create data and put it to table.
Now how to get form2 to just add some field into existing data ,and not creating aditional ones.
(My example TABLE: ASSIGNID,EMPLOYEEID,ITEMID,TAKENDATE,RETURNDATE
FORM1:entering all but RETURNDATE
FORM2: should enter RETURNDATE in existing data)

Please help

 

[namliam]

Why enter RETURNDATE on a seperate form tho??

The trick is to filter on the ASSIGNID, which I presume is the KEY of the table.

Look into the Openform command, in particular the "Filter" part of it.

 

[ACCESS NEWB]

Because it will be entered later

 

[sbooth]

Just create a 2nd form that includes the field that is not entered. You can sort or filter the records however you want.