Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

how to create checkbox to check the ones that we want to select

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marco - 28 May 2008 17:10 GMT
Hi. I have a form with a subform. the form runs over a query.

I would like to have a check box to select only records that I need.

I tried to create a checkbox control on the form but then when I select one
it selects me all records.

I already try to create in the query but happens the same problem.

How can I do this?

Regards,
Marco
KARL DEWEY - 28 May 2008 17:45 GMT
Is your checkbox bound to the query and in turn to the table?
Signature

KARL DEWEY
Build a little - Test a little

> Hi. I have a form with a subform. the form runs over a query.
>
[quoted text clipped - 9 lines]
> Regards,
> Marco
Marco - 28 May 2008 17:54 GMT
Hi. it's Unbound.

I don't have field in the tables to say, "CheckMe".

I tried, but because the base query that supports the form, is a non
updatablew query it doesn't work.

Do you think that my only change is to insert the query result into a empty
table and in that table I have a "CheckMe" field type Yes/No

Regards,
Marco

> Is your checkbox bound to the query and in turn to the table?
>
[quoted text clipped - 11 lines]
> > Regards,
> > Marco
KARL DEWEY - 28 May 2008 19:08 GMT
>>Do you think that my only change is to insert the query result into a empty
table and in that table I have a "CheckMe" field type Yes/No
It is according to what you intend to do with the records.  If you update
them then the orignal records still need updating.

Why not just use criteria in your query supplying records to the form?
Signature

KARL DEWEY
Build a little - Test a little

> Hi. it's Unbound.
>
[quoted text clipped - 24 lines]
> > > Regards,
> > > Marco
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.