I am trying to preload data to a new form when it is triggered from the first form. I can get everything there but the PhaseCode, probably because it is a DlookUp. Here is what I have so far:


DoCmd.openform "frmTravel", acNormal, , , acAdd, acNormal

PhaseCode = DLookup("[PhaseCode]", "PhaseList", "[PC]= '" & Me!PC & "'")

Forms!frmTravel![EmployeeNumber] = Me![EmployeeNumber]

Forms!frmTravel![JobDate] = Me![WeekEnding]

Forms!frmTravel![JobNumber] = Me![JobNumber]

Forms!frmTravel![PhaseCode] = Me![PhaseCode]

Forms!frmTravel![EarnCode] = 9

Forms!frmTravel![Total] = Me![WeekTotal]

Any ideas?

[This message has been edited by Talismanic (edited 11-09-2000).]

Talismanic
Looks like a simple syntax error to me.

PhaseCode = DLookup("[PhaseCode]", "PhaseList", "[PC]= '" & Me!PC & "'")

This looks OK, but I think that you are trying to store the DLookup return value in your variable (PhaseCode). If this is so, then you should leave off the Me! when you are assigning the value to the form..


Forms!frmTravel![PhaseCode] = PhaseCode

Try that and Good Luck
Chris