Seeing Records in a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

citloner - 17 Mar 2008 16:49 GMT

I want to open a form based on a table to only view certain records, for
example, paid customers only. I tried to base the form on a query but it
didn't work.

Please could you advise on how to do this?

Thanks.

Reply to this Message

ruralguy - 17 Mar 2008 17:18 GMT

The query should work just fine. How did you make the query? Did you use
the Query Builder? What did you put in the criteria area of your Paid field?
Did you check Datasheet view of the query to see what records would be pulled?

>I want to open a form based on a table to only view certain records, for
>example, paid customers only. I tried to base the form on a query but it
[quoted text clipped - 3 lines]
>
>Thanks.

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

John W. Vinson - 17 Mar 2008 17:56 GMT

>I want to open a form based on a table to only view certain records, for
>example, paid customers only. I tried to base the form on a query but it
>didn't work.
>
>Please could you advise on how to do this?

Correct the error in the form, or the query.

If you would like help doing so please post some more information. I can't
recall the last time I based a form on anything OTHER than a query - it's
perfectly routine and it does work. If you could explain what you did, and in
what way it "didn't work", someone can surely help get it sorted for you.

Signature

John W. Vinson [MVP]

Reply to this Message