Blank information on the Initial Record of the form

[Shar123]

When accessing a form for the first time, is there a way to show "no" values ont the form. When my users enter my form, I would like them to be prompted to go straight to my combo box and choose a name from the list. After which, the info will populate. However, at the present time when my users enter the form, there is pieces of information on the form until the user chooses a name from the list in order to populate the correct info.

Can this be fixed?

 

[Tim L]

I have to guess here that the 'pieces of information' are left over from previously opening the form and using the combo box? If this is the case try using the forms' On Open event to set the combo value to "" so that there is nothing for the form to reference and bring in. You may need to also run a requery/refresh on the form to ensure that it takes.

If that doesn't work, get back to us with more information about how the 'pieces of information' come to be present.

HTH

Tim

 

[RuralGuy]

I would leave the RecordSource of the form empty until the user makes the selection from the ComboBox. The form loads faster too.