>I am not sure how to go about this. I want the users to get the Windows prompt >screen to choose a printer. I then need to figure our how to grab the printer >that they selected. Then do use this in "set printer to my printer"? Or, do I >use the myreport.dbf and change it in the expr field. Any help would be >greatly appriciated.

I'd try and start with "sys(1037)" which is a printer dialog. Within the dialob you can choose which printer and many other properties i.e. landscape. the trouble with sys(1037) is that it sometimes it does not work the way you may want. If sys(1037) does everything you want great. The following is an example of code.

Normally I use sys(1037) just prior to printing:

...
=sys(1037)
report form myreport.
.....



Your earlier question asked how SBT handled the situation. They do many things that are not required in a controled enviroment. If you really just want the user to pick a printer then sys(1037) will most likely do the trick. If not then I think I'd check the files section for code or class to pick a printer. I know FOXPRO ADVISER had a couple of classes available.

SBT's use of the expr field works as follows:

The report 'frx' is really a table that holds the information for printing. Three fields "expr", "tag" and "tag2" contain information for the printer. I believe the expr field contains information on properties of the printer. Anyway I normally remove information from these fields to allow the report to use the default printer. SBT does the oppsite and fills the fields with information to insure that the report prints the way they want it to. SBT way is not a way I'd travel.

John