display no record when first opening form

[Liz Hansen]

Hi,

I have a form with a drop down box. The user selects a criteria in the drop
down box and the record is displayed. All this is working well.

What I want is a form that opens with no record displayed until a criteria
has been selected in the drop down box. So, to accomplish this I removed
the record source from the Form and instead added Me.RecordSource =
"tblparts" to the After Update event of the drop down box. This is working,
however all fields have #Name? displayed when first opening the form.

How can I correct this?

Thanks,

Liz

 

[Randy Fritz]

Hey Liz

When you took away the recordsource you made the form unbound and yet
all your fields are still bound to the table that now no longer exsists. if
you want to see nothing at the beginning yet have the fields refilled after
you have selected a criteria you empty the fields controlsource and when you
set your recordsource you then also need to set your fields controlsource.

Hope this helps
Randy