Form to write record to specific table based upon a value?

[whitelockben]

Is there a way to get a form to write a record to a specific table based upon a value?

Ideally this value would be True/False ie a check box or via a selection.

I have one form to input data but I want the record to be written to one of 5 fields based upon a value.

Thank you in advance,

Ben.

 

[Galaxiom]

Requirements like this suggest the data structure is not optimum.

 

[Robert88]

Hi Ben,

Spent a few hours and knocked this up.

It is an mdb zipped with winzip.

I hope it helps to answer your question.

Robert88