Question Sub-Form /Form Question

[bobburg]

I have a form that has header information and a sub-form that has detail informatiion on quotations. The user is supposed to enter data into both, however I have found some users any enter data in the header and leave the details contained on the sub-form blank. How can I force the user to enter data in the subform?

 

[ajetrumpet]

loop through the controls, check for NULLS and zero length strings in them, and pop a message that says something like:

all fields need to be filled in before moving on!

end of problem.

 

[bobburg]

I have very limited knowledge in Access. What do you mean by looping through the controls.

 

[ajetrumpet]

I have very limited knowledge in Access. What do you mean by looping through the controls.

do something like this:

dim c as control

for each c in me.controls

  if isnull(c) or c = "" then
    msgbox "Fill the entire form before preceeding"
      exit sub
  end if

next c