Seeing Records in a Form

  • Thread starter Thread starter citloner
  • Start date Start date
C

citloner

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.
 
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
didn't work.

Please could you advise on how to do this?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
Getting a Form recordset to a Report 4
Separate Form 0
Displaying Pictures on Forms 2
Second form to navigate to record displayed in first form 1
Form View 2
Go to specific record on form 4
Access Open Form with WhereCondition 6

Back
Top