Richard I'm trying to create a button on my parts form that will take info from 4 text boxes P/N, Part Name, MFG, and part location and send it to a table PartToPrint I only want the 1 row of lables. so when I export them to excel I can print the one P/N with the name ect.ect. the problem is if the table doesn't have info in it my macro wont run. it will give me an error saying cant run at this time. "because to table is blank".
I have this:in my macro
set warnings off =no
open table =parttoprint
run menu command= record go to first
run menu command=select all records
run menu command= delete records
open query = my query to select the records I want to print  
set warnings= yes
run menu command =export to excel
close window
is there some thing I'm missing that if the table is blank it will bypass and just run the query and not try to delete a record that is not there.  please help
Russ