Repeat previous value

Wis when I put =me.parent!height, I get error #name?
Dcrake I did this Me.Height = Nz(Height),DLOOKUP("Height","tblVisit","VisitID=" & VisitID)) and it highlights the comma before dlookup error expected end of statment the whole statement is RED. :confused:
 
As with all air code it is subject to error, in this case it should have read

Me.Height = Nz(Height,DLOOKUP("Height","tblVisit","VisitID=" & VisitID))

On too many closing brackets.
 

Users who are viewing this thread

Back
Top Bottom