Text Box on continues subform

[Guest]

Hi
I have a sub form which is set as continues.
When I select a name form the main form then the supform shows me a list of
all the same name.
A check box has been added to the subform so I can select the name which is
required however when the form is running and I click on one of the check
boxes they are all selected not just the name which I had clicked on.

Is there a way to make sure only the row which I select the check box in is
ticked and the rest remain unticked unless they are also selected.

Thanks
Noemi

 

[Guest]

Hi Noemi,

Sounds like you are using an unbound checkbox - because it isn't bound to a
record/control it shows the same for every record.

What is is that you are specifically trying to achieve? The selection of a
single record? For what reason?

If you provide a bit further info we might be able to help you out further.

Hope this helps.

Damian.

 

[Guest]

The problem is that this check box in UnBound (not linked to a field in the
table - the ControlSource of this check box is blank), when a value entered
into an unbound text box, all the records in that form will show the same
value.

The only thing you can do is create a field in the table (Yea/No) and then
link the check box to this field.

Or, instead of sub form use a list box with multiple selection enable.

 

[Guest]

Hi Damian

What I want to do is populate an excel spreadsheet with data from the
selection which I choose however I might have multiple records which need to
be added to the excel spreadsheet.

My train of thought was if I tick a check box then this will populate a
temporary table which will store the data for the selected record that will
then be used to populate an excel spreadsheet.

However I could have multiple records which will need to be entered on to
one spreadsheet while other's will have a new spreadsheet for entry.

This was the only way I could think of to able to populate the spreadsheet
when multiple data to be entered once all records required are selected.

I hope this make sense.

 

[Guest]

Well, in that case, add a Yes/No field to your table and bind your checkbox
to this field. Then, run a query similar to this:

select * from TABLENAME where YESNOFIELDNAME = true

remember to clear the yes/no field when you are finished, like this:

update TABLENAME set YESNOFIELDNAME = false

This will clear them all for you.

D.