Yes/No check box populates table with text

[Heathey94]

Is it possible to get a tick box in a form to populate a field in a table?



in my case for example, I have a range of questions which appear on different versions of a questionnaire. When a new version of the questionnaire is created, I want a new row to be created with all of the same values as the previous version, but the formversion field changes to the most recent version (which was entered on the form by the user).

If you don't understand just say so and I'll try to rephrase it, or if you feel having access to the database would be better, I can do that too.

[vicsaccess]

not sure i'm understanding. are you calling a record number a version? if so then yes with a little code.

[John_G]

Is it possible to get a tick box in a form to populate a field in a table?

Yes; just make sure the form has the table as its recordsource, then set the control source of the form checkbox(es) to the relevant table fields. The fields in the table must be set to data type Yes/No in design view.

Access actually stores the data as a numeric value (0 or -1); how you see it can vary, but a checkbox is one option.

[Heathey94]

vicsaccess - yes, sorry in my case the form versions are listed as records.

John_G - Apologies, I don't think I was clear enough - the field needs to be a text field (since a version could be 4A etc. and the tick indicates 4A needs to populate the field in the table).

[vicsaccess]

i think I'm getting lost with the terminology. do you have a sample DB you could post?

[Heathey94]

OK, so I've attached the database I'm working on, the forms in question are the EditLowRiskFormVersion (and also the Medium and High risk versions). I will create a similar version for adding the form versions, which is more along the lines of what I was describing earlier.

On the Edit versions of the forms, if a user unselects the "InVersion" check box, followed by clicking the "Update" button will delete that row from the table (not what I was originally talking about I know, but it appears I haven't yet created the add versions, and I don't actually know how to do this anyway...)

On the Add versions, the form will be displayed exactly the same, but the "VersionNumber" Combo will be a text box where the user will enter a new version number. Then, if a user leaves a check box selected for any "behaviour" that behaviour/record will be added as a new record, with the "VersionNumber" as displayed above.

Hopefully that is clear, if not just ask!

Thanks for your help