Solved #NAME? (1 Viewer)

[ClaraBarton]

Until I make a selection in a list box, the recordsource of a subform is blank. The fields say #NAME?. It all works properly so it's purely aesthetic, but I don't like the looks of the blank fields. How do you fix this?

 

[theDBguy]

Why is the record source blank? Try using an empty record source instead.

 

[ClaraBarton]

That's what it is. I Think? What's an empty record source? I'm setting the record source with VBA on the List after update

 

[June7]

Empty recordsource is a valid SQL that does not return any records but the fields are there. One way is:

SELECT * FROM yourtable WHERE ID = 0;

Set that in form design and change with your procedure.

 

[ClaraBarton]

Works Great! So simple! how come I couldn't figure that?