var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: To fill a form (is solved - don't need answer)
1. Form frmCase
1.1. Table tblCase
2. Table tblPeople
I would like to fill the form frmCase
with Name, Address...
knowing the Personal_ID that is into the Table tblPeople.
I'm sorry, but I'm bloqued...
Can you help me, please? (by code)
Last edited by jmruas; 12-14-03 at 15:14.
I found the solution...
Here is for those who needs this...
Dim db As Database, rs1 As Recordset
Dim rs2 As Recordset
Set db = CurrentDb
Set rs1 = db.OpenRecordset("Select * from tblPeople")
rs1.Filter = "[Personal_ID] =" & Forms!frmCase![Personal_ID]
Set rs2 = rs1.OpenRecordset ' here is the filtered record
Forms!frmCase!Name = rs2!Name ' here we fill the form with data from the filtered record
Forms!frmCase!Address= rs2!Address '
... ... ...
Set rs2 = Nothing: Set rs1 = Nothing
Set db = Nothing
Last edited by jmruas; 12-14-03 at 15:11.