Access 2007 datasheet form

[goodfu]

In Access 2007 is there any way to have a datasheet form (not a subform) with a header section that's visible so I can drop a combobox on it for filtering? I created a form that displays some records. When I change the format from Single to Datasheet the header disappears.

 

[boblarson]

No, you can't have a header on a datasheet view. But you can put a subform on a main form with the combo there and the subform not linked to anything and then set the subform's rowsource in the combo's after update event.

 

[missinglinq]

In addition to Bob's idea you could also use a Continuous View Form tweaked to look like a Datasheet View Form. You would then have the Header Section available.

Linq ;0)>

 

[Galaxiom]

.... and then set the subform's rowsource in the combo's after update event.

I know it sounds pedantic but I strongly discourage the use of incorrect terminology and this is the second post I have seen in the past few days referring to the "rowsource" of a form.

Forms don't have a RowSource property. RowSource is found in combos and listboxes.

You could set the RecordSource of the form based on the combo but I prefer to set the Filter property.

 

[boblarson]

Yes, yes, yes, yes, yes, yes, yes, yes, yes, yes, yes, yes, yes, yes, yes,

I was thinking Record Source but because I was also thinking Combo - Row Source came out.

I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source
I will not use row source for record source

I feel like Bart Simpson...

 

[Galaxiom]

I would have expected a more efficient solution from a programmer Bob.

 For i = 1 to 1000
     Debug.Print "I will not use row source for record source"
Next

 

[boblarson]

I would have expected a more efficient solution from a programmer Bob.

 For i = 1 to 1000
     Debug.Print "I will not use row source for record source"
Next

It doesn't have the same impact of a 5" long post on screen.

 

[goodfu]

Writing I will not blah blah blah over and over is punishment. Teacher won't let you use a loop.

Thanks.

By the way, I don't get an email everytime somebody puts in a post.

 

[SaviorSix]

I would have expected a more efficient solution from a programmer Bob.

 For i = 1 to 1000
     Debug.Print "I will not use row source for record source"
Next

Compile error:
Variable not defined

 

[boblarson]

By the way, I don't get an email everytime somebody puts in a post.

You won't. You only get a notification email for the FIRST post that occurs after your last visit to the thread. If you visit the thread right after each post and you aren't in the thread when the next post is made, you will get a notification for that next post as well.

 

[Galaxiom]

Compile error:
Variable not defined

Only with Option Explict.
Most teachers's will give more detention for using explicit language.