requiring [supplier] if [rdoNO]=True

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which will display one of several different question groups.
On this form, if the radio button "NO" is selected you must make an entry in
the [supplier] field. I conditional format the [supplier] field to enable if
"NO" is selected and when the "Audit Complete" button is pushed you will get
an error is [supplier] is null and "NO" is true. Part of the code on the
"Audit Complete" button is to move to another record thus updating the table.
This worked great until I get to one of the question sets which only has one
question. I can't move away from the record and update the table in the
prescribed manner. I can do a send keys command (shift F 9) I think or use a
macro to close and reopen the form but this seems sloppy to me. Can someone
point out a smart solution?
Thanks.
 
Never mind, I figured it out. I inserted code in the event associated with
the "Audit Complete" button which updated the answer in the table before
checking to see if the supplier field is required.
 
Back
Top