subforms and null records(ish)

[SDB]

Hi All

I have a form for booking employee holidays and in that I have a subform that displays their current holiday entitlment, which work great until I enter in a new record on the main form to book some holidays and I'm ask for a Name from a parameter box?? which I press cancel or ok at which point the subform goes blank (which is whatI want) but when I enter the employees name from the combo list it doesn't update the subform?

my question is; how do i remove the parameter box and update the subform once I have selected the employee name??

cheers

 

[carash77ash]

a parameter box is linked to an sql staemnet either in vba or the form is generated from a query. With the name field is it set to lookup a table that no longer exists or is the sql statement you are using have a criteria associated with it.


Ash

 

[SDB]

cheers crash77ash, having read your reply, i found the problem, I made thr basic mistake of name my employees filed Name..changed it to EmpName and all works well.

cheers