my report is loseing its columns

[PWise]

how do i keep my report from loseing its columns when i run it with "DoCmd.OpenReport reportname, acPreview" this is in a2k i work mostly in a97 never had this before i dont know if this always happens

 

[Darrylles]

Hiya,

Please explain in more detail what you mean by 'losing columns'.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[PWise]

HI Darrylle
I have a report that I created with the label wizard I selected a three column label. The record source is a query when I open the report from the database window it has its columns as many times as I open it. The way my client should open it is from a form that has a 2 column combo box and a command button it the on click event I can change the sql of the query with
Dim mydb As Database
mydb.QueryDefs("queryname&quot.SQL = sqlstring
DoCmd.OpenReport "reportname", acPreview

The first time I open it works fine (3 columns and the margins the way I set then) the next time it only has one column and the margins are 1". When I reset the margins and the columns and open it thru the form the first time it work fine and next time the margins and columns are reset

pwise

 

[PWise]

i found a answer in
thread703-418647