M
Miss Teacher
Hi!
I'm an Access beginner.
I need to be able to choose a statement from a memo field (populated from
the user choice of a previous choosebox).
I have used excellent advice from an article here regarding basing one
combobox on another, and have developed a lovely line of them, each depending
on the previous one.
I am creating a teacher's curriculum database for planning, where I need to
choose KLAs, Curriculum Organisers etc, the last combobox needs to choose a
statement from a list of 4 to 10 statements.
The combobox wizard (my previous procedure) does not incorporate the memo
field. I tried to get my box working without it, but the box does not appear
to receive the data.
I then found advice on using a DLookup statement in the Control Source field
that I have managed to suceed in getting to work, however, it is not allowing
me to actually 'choose' from this combo now. It says as I hold the mouse down
to choose in form view, "Control can't be edited: It's bound to the
expression DLookup..." etc.
The contents of this form will need to be saved into a row on another table
for my curriculum planning.
How do I get around this? I need to save the whole memo field to the new
table, and I need to be able to choose a statement from this last combobox.
Thanks in advance for any help.
I'm an Access beginner.
I need to be able to choose a statement from a memo field (populated from
the user choice of a previous choosebox).
I have used excellent advice from an article here regarding basing one
combobox on another, and have developed a lovely line of them, each depending
on the previous one.
I am creating a teacher's curriculum database for planning, where I need to
choose KLAs, Curriculum Organisers etc, the last combobox needs to choose a
statement from a list of 4 to 10 statements.
The combobox wizard (my previous procedure) does not incorporate the memo
field. I tried to get my box working without it, but the box does not appear
to receive the data.
I then found advice on using a DLookup statement in the Control Source field
that I have managed to suceed in getting to work, however, it is not allowing
me to actually 'choose' from this combo now. It says as I hold the mouse down
to choose in form view, "Control can't be edited: It's bound to the
expression DLookup..." etc.
The contents of this form will need to be saved into a row on another table
for my curriculum planning.
How do I get around this? I need to save the whole memo field to the new
table, and I need to be able to choose a statement from this last combobox.
Thanks in advance for any help.