Form to load showing all fields blank

[Russie]

Hi.

This is probably a simple question but...

When you have a form with a combo box on it that selects records how do you make all of the fields on the form display no data until a record is selected?

Thanks.

Russie

 

[TheAceMan1]

How are ya Russie . . . . .

You can set the [blue]RecordSource[/blue] for the form to nothing. Then on selection fron the [blue]Combobox[/blue] [purple]set the Recordsource proper.[/purple]

See Ya! . . . . . .

 

[Russie]

Thanks Ace.

When I clear the record source for the form and load it I get a #Name? error on all fields. Obviously because the control source for all fields are set it is trying to resolve the table name.

What did I do wrong?

Thanks.

 

[TheAceMan1]

Russie . . . . .

Yes . . . . your right, thats exactly what should happen! I was thinking of something else.

I have two alternate methods (that work) but can't post until later on today . . . . Just hang in there . . .

See Ya! . . . . . .

 

[TheAceMan1]

OK Russie . . . . .

In form design view, set the [blue]Data Entry[/blue] property of the form to [purple]True[/purple]. This causes the form to open with a single blank record for data entry.

Then, in your code for the combobox, at the beginning of the code, set the property back to false:

[blue]   Me.DataEntry = False
             [green]'
         Your Code
             '[/green][/blue]

See Ya! . . . . . .