Checkbox and Continuous form again

[Mike]

Hi all

Can't seem to find the answer I'm looking for and I tried just about
everything I've read on here already. Maybe someone can help out.

I need a list of medications to display and then allow the user to
check off certain meds. Been having the usual problems. Based the form
on a query to display the meds and had an unbound checkbox but of
course when one was checked all would check. Tried to add a boolean
field to the query but it wasn't updateable on the form. Tried binding
the form to the table and using DLookup for the list but only the first
med (not the whole list) showed on the form. I've been going back and
forth and can't seem to make any headway.

Any ideas?

Thanks
Mike

[jleckrone]

How many entries does your list of meds have? Are you wanting a
separate form to open so you can enter the medication info? Please
clarify.

Mike wrote:

Hi all

Can't seem to find the answer I'm looking for and I tried just about
everything I've read on here already. Maybe someone can help out.

I need a list of medications to display and then allow the user to
check off certain meds. Been having the usual problems. Based the form
on a query to display the meds and had an unbound checkbox but of
course when one was checked all would check. Tried to add a boolean
field to the query but it wasn't updateable on the form. Tried binding
the form to the table and using DLookup for the list but only the first
med (not the whole list) showed on the form. I've been going back and
forth and can't seem to make any headway.

Any ideas?

Thanks
Mike

[Jeff]

Throw all the medications into a buffer (a table where they are held temp).
This table only needs the id of the med and a boolean field for the
checkbox. Build a query based on this table, link to the meds table to get
the properties to display. Build you form based on this query and bind the
checkbox to the boolean field.

Do whatever with the data in the buffer after users have checked the
necessary meds.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"Mike" <mi***@pitt.edu> wrote in message
news:11**********************@y43g2000cwc.googlegr oups.com...

Hi all

Can't seem to find the answer I'm looking for and I tried just about
everything I've read on here already. Maybe someone can help out.

I need a list of medications to display and then allow the user to
check off certain meds. Been having the usual problems. Based the form
on a query to display the meds and had an unbound checkbox but of
course when one was checked all would check. Tried to add a boolean
field to the query but it wasn't updateable on the form. Tried binding
the form to the table and using DLookup for the list but only the first
med (not the whole list) showed on the form. I've been going back and
forth and can't seem to make any headway.

Any ideas?

Thanks
Mike

[Albert D. Kallal]

A list box is better for this, as you can display the list of medications,
and if you set the multi-select to true, and then after you can easily
process this list..

Thus, you might consider a listbox in place of a continues form.

However, I do have a sample download that shows you can use a un-bound check
box in a continues form. You can find it here
http://www.members.shaw.ca/AlbertKal.../msaccess.html

Grab the multi-select example.....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal