MS Access tables and VBA

I have several tables with the same structure and data. The difference is the name of the table. The names of the tables are PalmPilot users. I have a hotsync program that I use to send "all" the Palm DBs to the palms. What I want to do is use the Palm name (which I can get during the Hotsync process). In the tables I have two fields. One is the table to be sent to the palms and a yes or no (text). So from the VBA for this Hotsync I have all the commands to send these files to the Palms. What I want to do is take a String of the Hotsync user and use it to look at the appropriate table and ascertain what to do with the tables. Sorta like:

Dim hsu
hsu = hotsync name

then
If hsu.cust = yes then (sync customer data)
End if
If hsu.calendar = yes then (sync calendar data)
endif
If I use the above the files are not copied to the Palms, no matter what is in the tables either a yes or no. Have any suggestions?
Thanks