Writting and If / Then

[drewcp]

I have my main form, Batch Query, which has three sub forms
1 - Batch Query Subform
2 - DataEntry
3 - Photo

the DataEntry sub form has 5 sub forms on it
1 - UTADBA_BATCHING2
2 - UTADBA_PARCEL
3 - UTADBA_LAND
4 - UTADBA_RESIDENCE
5 - New Growth

on my main form i have text box that populates a list box on my Batch Query Subform

on that list box, i can click on an item and it runs a series of queries to update the information in my subforms in DataEntry

All of my subforms on DataEntry are based off of queries

1 - Batching
2 - Land
3 - Parcel
4 - Residence
(New Growth and UTADBA_PARCEL both come from Parcel query)

so what i am trying to do is after my listbox updates all of my queries and forms, i would like it to check and see if any of those 4 queries do not have any records in them. If one does not have any records in it, then i would like to run an append query (which i have already made)

I have tried to do if/then statements to accomplish this in the vba code to run in the "on click" of my list box, but i am using the wrong syntax because i can not get it to work at all.

here's are links to a visual of my Batch Query form to help it make more sense as to how it is set up

http://qvepgq.bay.livefilestore.com...P-oLwr06oLN1g-Hc1MICaJ7HDnDY/Screen Print.bmp

http://qvepgq.bay.livefilestore.com...Qq3MyNIXomxJOc4t5EMYwtfaJU/Screen Print 2.bmp

If anyone could help me out with this it would be greatly appreciated

 

[MajP]

The screen captures are of no use. We would need to see your attempted code and the sql for your query.