Append query

  • Thread starter Thread starter TT
  • Start date Start date
T

TT

I have a form to append information to a table. On this
form their are several combo boxes. If a combo box is
selected with information and when the form is finished
being filled in then it appends information to a table.
My question is do I need to make a different append query
for each item or can I make one query? I want to make
sure before diving into this. If a combo box is not
selected than that item is not appended but the other
items are.

Thanks for any assistance
 
hi,
you can do it all with 1 query. what you need is to add
some qualifiers to your code before you run the query.
something like
sub runquery()
if isnull(combobox1) then
msgbox ("fill in the box stupid")
exit sub
else
if isnull(combobox2) then
msgbox("fill in this one too jerk")
exit sub
end if
end if
run append query
end sub
this way(with the exit sub part if a box in empty) the
append query doesn't run until all the required field are
filled in.
 
Back
Top