Text Box on continues subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noemi - 17 May 2007 06:23 GMT

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

Reply to this Message

Damian S - 17 May 2007 06:56 GMT

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.

> Hi
> I have a sub form which is set as continues.
[quoted text clipped - 9 lines]
> Thanks
> Noemi

Reply to this Message

Noemi - 17 May 2007 07:12 GMT

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.

> Hi Noemi,
>
[quoted text clipped - 23 lines]
> > Thanks
> > Noemi

Reply to this Message

Damian S - 17 May 2007 07:36 GMT

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.

> Hi Damian
>
[quoted text clipped - 41 lines]
> > > Thanks
> > > Noemi

Reply to this Message

Ofer Cohen - 17 May 2007 06:56 GMT

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.

Signature

Good Luck
BS"D

> Hi
> I have a sub form which is set as continues.
[quoted text clipped - 9 lines]
> Thanks
> Noemi

Reply to this Message