Form with check box Help

  • Thread starter Thread starter DP7
  • Start date Start date
D

DP7

Hi I am having an issue with a access form that I am trying to create from a
query with a check box involved. Let me explain. Users can click a button to
run a query that will bring up records that match whatever date criteria they
put in. When the resulting form comes up, I added a check box to that form.
When the user selects these records using the check box then clicks a button
I added to the form it is supposed to bring up a second form with the
selected records showing different fields that need to be field in. However
when I press the button to run the second form the results is not correct at
all.
t is not correct in that if I have the first 2 check boxes selected & press
the button to bring up the related form it only bring up one record. If I
have 4 records selected it only brings up 3 on the form. It seems to not be
coming back with the last selection in the group. Also if I have none of the
check box selected & click the button it will bring back one record on the
form. Below is the SQL statement of the form that runs when u click the
button
If you need any more info please don't hesitate to ask


SELECT ChangeDateQuery.Selected, ChangeDateQuery.[EBA PO NUMBER],
ChangeDateQuery.[CUT RELEASED TO GUATE#], ChangeDateQuery.[STYLE#],
ChangeDateQuery.COLOR, ChangeDateQuery.CAFTA, ChangeDateQuery.[BRIGGS
DIRECT], ChangeDateQuery.COMMENTS
FROM ChangeDateQuery
WHERE (((ChangeDateQuery.Selected)=True));
 
Hello DP7.

DP7 said:
Hi I am having an issue with a access form that I am trying to create
from a query with a check box involved. Let me explain. Users can
click a button to run a query that will bring up records that match
whatever date criteria they put in. When the resulting form comes up,
I added a check box to that form. When the user selects these records
using the check box then clicks a button I added to the form it is
supposed to bring up a second form with the selected records showing
different fields that need to be field in. However when I press the
button to run the second form the results is not correct at all.
It is not correct in that if I have the first 2 check boxes selected
& press the button to bring up the related form it only bring up one
record.
[snipped]
Click to expand...

Save the record before opening the second form:
DoCmd.RunCommand acCmdSaveRecord
 
Back
Top