J
jer99 via AccessMonster.com
I have a table of audits.
An audit is related to many comments. The audit has an unique IDAudit, a name,
a date range and a client among other fields.
Since an audit can be redone and I wish to keep the details of each "re-do",
I just add a new record (IDAudit is autonumber) for the same date range and
client.
I wanted to record which audit record was the original for a specific client
and date range. So I had this brainstorm to add a field called "Audit_Set".
The Audit_Set would equal the ID_Audit of the original.
Cool.
Now I have my Audit entry form and I give a new audit a name. I would like to
have a CBO box that shows what the original audit was and if it is empty,
allow me to select one from a list of all audits for the particular client.
I've given myself a headache. I cant seem to figure out if I need to do
something in VBA after the update of the audit name, or if I need to do
something in the CBO. I'm assuming that the CBO should be left unbound.
Any help would be greatly appreciated!!!
An audit is related to many comments. The audit has an unique IDAudit, a name,
a date range and a client among other fields.
Since an audit can be redone and I wish to keep the details of each "re-do",
I just add a new record (IDAudit is autonumber) for the same date range and
client.
I wanted to record which audit record was the original for a specific client
and date range. So I had this brainstorm to add a field called "Audit_Set".
The Audit_Set would equal the ID_Audit of the original.
Cool.
Now I have my Audit entry form and I give a new audit a name. I would like to
have a CBO box that shows what the original audit was and if it is empty,
allow me to select one from a list of all audits for the particular client.
I've given myself a headache. I cant seem to figure out if I need to do
something in VBA after the update of the audit name, or if I need to do
something in the CBO. I'm assuming that the CBO should be left unbound.
Any help would be greatly appreciated!!!