Can I still use check boxes?

[Allen Browne]

You lost me. I don't see how your question about entering data into text
boxes and check boxes relates to the problem of having too many records in
the recordset. Once you combine more tables in a query, it may become
read-only, but that's another problem again.

Perhaps you could post a new question.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen
Thank very much indeed for your kindness.

If I understand your message that means:
1. I can not enter data in txtboxes and in checkboxes at a time and then
click the filter to show the records founded
2. I can not use another set of check boxes to filter records from another
table.
3. How can I do to show the records in another form rather than in de
Detail
section?
3. Or do I have to formulate a new questions to the forum?

Thanks again

[snip]
One table is to search by checkboxes as well. However, I’m facing this
problem. For example, when I click chkBio the filter displays 5
records.
If I add another table (and the required field) to the query clicking
chkBio will filter 10 records. Why?

This is a new question. It has to do with the way queries work.

If you add Table2 to a query, and it has 2 records matching the one in
Table1, the query that previously output 1 record will now output two.
Hence, 5 records can become 10 when you add another table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

.

 

[sebastico]

Allen

I really apologize for misunderstanding your message.

Yesterday I posted another question with subject: How to use Or in txtbox?
Thanks again for your kindness

You lost me. I don't see how your question about entering data into text
boxes and check boxes relates to the problem of having too many records in
the recordset. Once you combine more tables in a query, it may become
read-only, but that's another problem again.

Perhaps you could post a new question.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen
Thank very much indeed for your kindness.

If I understand your message that means:
1. I can not enter data in txtboxes and in checkboxes at a time and then
click the filter to show the records founded
2. I can not use another set of check boxes to filter records from another
table.
3. How can I do to show the records in another form rather than in de
Detail
section?
3. Or do I have to formulate a new questions to the forum?

Thanks again

[snip]
One table is to search by checkboxes as well. However, I’m facing this
problem. For example, when I click chkBio the filter displays 5
records.
If I add another table (and the required field) to the query clicking
chkBio will filter 10 records. Why?

This is a new question. It has to do with the way queries work.

If you add Table2 to a query, and it has 2 records matching the one in
Table1, the query that previously output 1 record will now output two.
Hence, 5 records can become 10 when you add another table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

.

.