I need help with Form Thanks

[hmho]

Hi, I have continuous Form that I have two fields that using Dlookup. When I don't enter the look up filed or when I first open the form the fields for the look up are showing (error) but when I enter information is working fine. How do I move the error default. Thanks

 

[ajetrumpet]

need to see more pictures of this, or more information. the question is too vague to answer.

 

[marianne]

ofcourse it will show error because it is already bound with your expression dlookup. why dont you make a code after_update in your lookup field to do the dlookup function instead of bounding the field instantaneously.

 

[hmho]

I'm very new to this how do I do that? Thanks

 

[marianne]

anyway what is the purpose of dlookup in your two fields of your continuous form? is your continuous form a SUBFORM inside the MAIN FORM?

 

[hmho]

I was able to put NZ and it worked thanks